Forum Discussion
Solved
Filtering calculation group items
Hi forum. Does anyone know if it is possible to set up a slicer or filter to do filtration on which calculation group items to show in a report? That would be some kind of dimension that enables th...
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.
Okay - I get it. As we have no way to create a relation to the "Ordinal" column there really isn't any grouping or filtering options.
Thanks for clarifying.
MonsterJoe
No problem.