Why do values change when I click on table??

[jlampard40]

I have created a straight table.  The figures don't look like right, until I click on one of the lines and then the values show exactly what I want it to show!  The expression I am using is as follows:

=Num(avg({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Aggr(count({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Event_Key),Financial_Year_Week)),'#,###.')

This is showing the average weekly demand, for financial year FY19/20, using demand only and counting using Event Key (unique identifier).

The table looks, as per attached (pic 01) at first (wrong figures).  But when I click on, say XR, it shows the result in pic02 attached which is the correct figures!!??.  Can anyone shed any light on this??

Many thanks.

[lironbaram · Accepted solution]

hi 

actually it's not that complicated , 

aggr function is unique because it disregards the table dimensions , so i your case it doesn't consider modality dimension 
so you get wrong figures 

you need to modify your expression

=Num(avg({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Aggr(count({<Activity_or_Demand={'Demand'},Financial_Year={'FY19/20'}>}
Event_Key),Financial_Year_Week,Modality)),'#,###.')

[jlampard40]

Thanks very much!  Best regards