Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am using a pivot table and in calculated dimension I am using below expression
Aggr(If(PTG=PT,'G','R'),Product) which is giving the desire output ..
But I need to pass the below expression into the above calculated dimension
Count({<sev-={'5'}>}ID)
I am really stuck with this need your help
Thanks in Advance
John
please explain your requirement using some sample data and your expected result as well.
Thanks for the reply @MarcoWedel
Basically I am trying to show a column in pivot table with 'G'(Green) and 'R'(Red) . below is my table
Here I am using calculated dimension as Aggr(If(PTG=PT,'G','R'),Product) hence getting the above out put
and I have a Expression as Count({<sev-={'5'}>}ID)
My above calculated dimension should pass the other considering the expression within it .
To achieve this I am tried this below logic and this show expression is okay but doesn't work properly
=aggr(if(PGT=PT and Count({<sev-={'5'}>}ID) >0,'G','R'),Product)
Hence seeking help to know how can I include the expression within the calculated expression to make output work properly
Thanks
Hi all
Any help on my post
Tried with all the possibilities but not able to achieve the expression .