Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Pivot table Totals Not Showing....?

Can anyone guide me why my pivot table is not showing Total values?

Segment is a synthetic dimention .

WeekInMonthDaySegmentabcdefghiTotal
Week1Sun000000000-
Week1Sat000000000-
Week1Fri02403,14476600(862)0-
Week1Thu00036(144)00(143)0-
Week1Total02403,18062200(1,004)0-
Week2Mon0(144)4,39211,7771,018084(42)0-
Week2Sun000000000-
Week2Sat000000000-
Week2Fri04671,56514,611586004550-
Week2Thu01,198(1,885)9,077382002,1540-
Week2Wed0002,153(862)(30)000-
Week2Tue00011,056001,771(0)0-
Week2Total01,5204,07248,6751,123(30)1,8552,5670-
Week3Mon(599)8204,22514,6381,46001,0181,1240-
Week3Total(599)8204,22514,6381,46001,0181,1240-
Total(599)2,3648,29766,4923,205(30)2,8732,6870-
2 Replies
preminqlik
Specialist II
Specialist II

use aggr

sum(aggr(<presentExpression>,dimension1,dimension2,dimension3))


Not applicable
Author

Prem,

Thanks for the replay.

But what if I am using 'value list' for SynDim within in the chart?

I can create the Dim from the script side to with "aggr" but is there any way I can solve this within the expression?