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.
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