I actually did same logic into new sheet and it worked OK on new sheet with table, and still doen't show anything on old one.
What could it be ??
Is there any way to see what kind of element it is, it's very helpful if you working on old app, let say how to say is it pivot table or just table, is there any property I can see this ????
I used exactly same build steps for both tables and one of them still doesn't have Totals. So I don't think it's b'z of any aggr syntax. Probably something didn't get reversed accordingly during development. I works OK on freshly made table.
I saw this happening in SSRS when reversing changes sometime don't work.
In both cases I used:
aggr(If((IN_CURR_FY = 1 and vSW = 1) or vSW = 0, MEASURE_DATE), MEASURE_DATE)
+ cleared <Show Null Values>
So I think I'll let this issue go..