Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good Day
Please assist:
I would like to create a bar chart based on a certain criteria without using a "filter pane".
eg. Names column, I only want the revenue/loads/sales that "Sam" did and not the others.
Thanks in Advance
You can use set analysis, for ex:
Sum({<Names={'Sam'}>}Revenue)
-- above exp gives sam revenue alone.
You can use set analysis, for ex:
Sum({<Names={'Sam'}>}Revenue)
-- above exp gives sam revenue alone.
Thanks @MayilVahanan
with the same example, how will i exclude a certain name and display Revenue for all others?
Thanks in advance
If you want to exclude certain names, try like this
Sum({<Names-={'Sam', 'Mayil', 'Ram'}>}Revenue)
-- above will exclude Sam, Mayil & Ram revenue.