I have a pivot table. The points expression is not giving the sum of rows. I understand that I need to use the aggr() to get the correct sum of rows but I am not able to correctly place that function. Can anyone please help? Thanks!
Dimension is a calculated dimension : If((isnull(WinLossDate) or num#(WinLossFiscalYear&num(WinLossFiscalQuarter,00))<'201201'),null(),Owner)
I would recommend that you try and add your calculated dimension to the data model during application reload, so that you get a real dimension in your chart. Then you can create a column total by using Aggr(), where you list all dimensions in your chart.