I have a data as below
Country State Region Revenue
C1 S1 R1 10
C2 S2 R2 15
C3 S3 R3 20
C4 S4 R4 25
I want to display in Xcelsius Dashboard as below
Country State Region Revenue
All All All 70(total of All)
All All R1 XX
All S1 R3 XX
All S4 All XX
C1 S3 R2 XX
C3 S2 R4 XX
like so on......
I am using Country, State, Region on 3 ComboBoxes and for revenue using Gauge.
Very thankful if any solution is posted.
Regards