I want to show all the data in the pivot table even after selection of some particular data...
i am using this type of expression and it is not working:
=if(AncestorId='PAR007' ,prioryearfixed,
if(AncestorId='PAR009',priorWorkingCapital,
if(AncestorId='PAR010',priorOperatingWC,
if(AncestorId='PAR011',priorCurrentRatio,sum({<str_pov_name={'ACTUAL'},str_fy={$(#vPriorYear)}>}money_measure)))))
where prioryearfixed,priorWorkingCapital,priorOperatingWC, priorCurrentRatio, vPriorYear are my variables consisting some expressions .
like =sum({<AncestorId={'BS02A','BS02B','BS02C'},str_fy={$(#vPriorYear)}>}money_measure)
and vPiorYear is =Num(str_fy)-1
so in this i was using sum({1} 0) with all the expessions but it is not working.
Please help.
Thanks.
