I have three columns in my report: Group,Category,Nominal. I only want the Nominal rows to show for one of the Categories, but I want the totals for Category and Group to include all data, so I can’t filter anything out. I have tried using Breaks but that doesn’t seem to work, and I don’t want to set up groups of values if it means that I have to keep updating them every time the Nominal objects are amended.
Any ideas on how this can be achieved please?
Could you create a representative object for nominal (pseudo code, my Deski is v rusty!) of:
=IF(=“My Category” Then Else “Others”)
Then you will have a line for each Group/Category combo of Others, apart from where your Category is “My Category”, where it will give a full list of Nominals.