+3
Hi everyone,
Has anyone come across the need to sum data across different slices?
We have three separate entities, each forecasting under a different scenario (as shown in the table above). We’d like to sum these three combinations together, but we haven’t been able to do this using the Sum function on the View/Board or Add Calculated Items (as it only allows adding two items instead of three)
Would really appreciate any advice if you’ve solved something similar.
Cheers
Neo
+2After adding the slice into the pivot for a view, were you not able to sum using aggregator?
We have a slice with 2 columns and I used aggregator to generate sum total.
+3After adding the slice into the pivot for a view, were you not able to sum using aggregator?
We have a slice with 2 columns and I used aggregator to generate sum total.
Thank you, I also need to show Scenario under the Slices (e.g to show which Scenario being used by which Entity), hence why aggregator won’t work, it shows a Total with a subtotal. (see snip below)
Aggregator works when I remove Scenario from the Columns in the Pivot though.
+13Hi
Native Scenario’s can’t be aggregated. As scenario’s in the background are more an app copy than a dimension itself Pigment won’t be able to show you the total of both.
You would have the same limitation without slices.
Instead of scenario’s have you considered adding an Entity dimension to your model? You could also bulk copy the scenario inputs to another one so you would be able to see the data on a single scenario.
+3Hey
I tried adding Entity dimension to the column but wont work for what I need, also bulk copy I think I will have to do it every time new inputs are added to each Entity x Scenario so won’t be able to have a live data to work with.
Will have to take Scenario out of the Pivot, and rename the Data Slices differently.
Thanks anyway :)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
