Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a page with 3 filters: Month, Group, Org. I limit "Month" to a single selection to show a KPI chart. But in a trend chart, I need to ignore the year limit, and the "Group, Org" selection is still valid. How should I write the expression ?
Hi, in set analysis you can ignore field selctions just writing the field name, so if you expression is "Sum(Sales)", ignore Year field can be done as: "Sum({<Year>} Sales)"
Hi, in set analysis you can ignore field selctions just writing the field name, so if you expression is "Sum(Sales)", ignore Year field can be done as: "Sum({<Year>} Sales)"
It works, tks very much!