Hi,
Working on a forecast model that has one page for each Director, and a total page for the VP that is the sum of the 4 director pages.
There is only 1 data set.
All Directors have identical filters available to them (15 in total), but can choose whatever they like to create their own custom view.
Slicers are not sync'd accross the report as the directors can choose to include or exclude whatever is relevant to themselves.
The Pages all have 1 Table visual with an identical product column and a $ column.
Eg: (Director 1)
Product | Value
Cars | $50
Dogs | $25
Cats | $25
Total: | $100
The directors choose their respective filters and their tables total:
Director 1 total = $100
Director 2 total = $150
Director 3 Total = $120
Director 4 Total = $180
The VP page will have an identical table visual but the $ column needs to be the sum of the 4 Directors individual totals. The VP page will not have filters, it's simply a summary of the other 4 table visuals on the other pages and should equal $550 using the above example.
How can I create a Sum of the four separate visuals?
This is built in desktop and published to a premium workspace.
Thanks,
Marc
