Excel PivotTable With Slicers and Timeline: Interactive Report Design
Design a one-page interactive report from a raw table.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.
Design an interactive report in Excel based on PivotTables, slicers and a timeline. Raw data columns and a sample: [DATA_SAMPLE]. Audience and the questions they ask: [AUDIENCE_QUESTIONS]. Screen or print: [OUTPUT]. Give the layout of the report page: which PivotTables and charts, what each shows, where the slicers and timeline go, and which slicers control which items (report connections). For each PivotTable specify Rows, Columns, Values and Filters, the summary function, number formats and sort order. Include two calculated values with formulas and a worked example. Make it readable: hide field buttons, fix column widths, and show the current filter state in a text cell, since a slicer left on a filter or an incomplete period can mislead. Name slicers sensibly and keep their number small enough for one page. Checks before sharing: refresh, test each slicer, compare the grand total with the source, and look for blank or error items. When new data arrives, use a table as the source and refresh all. Give the build steps in order and mark menu names that may vary [VERIFY].
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.