Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have created a calculated dimension;
if(abcd<>'Total',abcd)
In front end, if i select a particular value from this dimension abcd, it will show in current selections as
if(abcd<>'Total',abcd)
how to resolve this issue?
Hi there Sanju
Do you have access to the load script? Then you can use something like this:
LOAD
*,
if(abcd<>'Total',abcd) AS TestField
FROM ...
After this you can add TestField as a dimension and when you make a selection, it will show TestField (or whatever you call it) in the selection bar.
Not sure how you can do it in the front end though.
Hope this helps.
Mauritz
Hi Sanju,
You can create a dimension in the asset panel with that expression and use it in your chart. Check my example at
Regards,
Patrik.