Please attach a .twbx
Thanks Shin taking time. But i am looking different way. I want only one column which do the avg of sales for states and Sum(avg sales) for Grand total / Sub total. I can do by using the 'total all using - average' from the analysis tab option. But my problem is i want measures to be used as filter. When i used in filter i have to go manually and change the option in the report which is not suitable. Can we do LOD i am not sure how to achieve this with LOD
I am confused what you are seeing?
Take one month s example.
Avg column total is average and sum columns's total is sum.
Both avg and sum is calculated (aggregated) field not row record.