Hello! I am working on a project to visualize pension fund data for public use -- the idea is that a user should be able to select which funds and how many fiscal years of data they would like to view.
I would like to set up a dashboard such that the sheet with the data is displayed when =>10 years of data are selected and when <10 years of data are selected it displays a different sheet that reads "Please select no more than 10 fiscal years."
I have tried to play around with parameters as some other tips on the forum suggested, but I can't seem to get it to work. Any advice or tips would be greatly appreciated!
DZV can only be used with a calculation that evaluates to a constant at the workbook level, and is performed before any filtering, hence doing anything with FIXED and Context filters will not have the desired effect. If you switch your filtering to use Sets instead of a Dimension, then you can do something like:
{ FIXED: COUNTD(IF [Sub-Category Set] THEN [Sub-Category] END) >= 10 }You'll have to create a second field for < 10, because if you use NOT [That Field] the DZV functionality will not display the field as an option to control display, despite it being a constant at the workbook level. One of the idiosyncrasies of DZV.
