Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have 1 filter pane and 1 bar graph
in filter pane have zone values (africa, india, japan, canada, Uk , Austrelia, N/A)
without any selection only (africa, india, japan, canada, Uk , Austrelia) profit should appear, N/A should not be there
but when i select N/A from filter pane N/A then bar graph should show sales of N/A
kindly help me out
This perhaps.
=If(GetSelectedCount(zone), Sum(Sales), Sum({<zone-={'N/A'}>} Sales))
can you pls describe in detail pls
how i should apply
That should be the bar chart expression, where "N/A" is excluded by default but included when the user explicitly selects it or other zones.
and what about other filters it will work accordingly or not