Forum Discussion
Filtering calculation group items
MonsterJoe
No problem.Yes, this is possible.
As SpartaBI experienced, I also get an error if I try to create a relationship with a calculation group.
However, a workaround is to add a calculated column to the CalculationGroup table and use that column on a slicer.
Please see the attached as a simple working example.
In this aspect it's like any other column. You can put that column in the report / page / visual level filter, only choose the ones you want to be availalbe and hide / lock that filter. Than add another one visible so users could choose from it
That's of course true.
I am looking for a data driven way – i.e. having a large amount of calc items in a calc group - and having the items mapped to a “grouping” attribute in another dimension.
Good one 🙂
I assume you tried creating that dimension and couldn't connect it to the CG table.
Never tried it, and just did, and it's not possible.
Will try to think of it and update if I came up with something or not