I'm having trouble setting up the dashboard in Excel. I have information about sales, clients, and meetings. The type of transaction is listed in one of the columns (for example AAA, BBB, etc). There is often only one type of transaction for each row, but occasionally there are two or even three.
So for example it could look like this:
I wanna create a dashboard with slicers and Pivotcharts, but when I do slicer based on the Column "Type" it gives me three values to choose from: AAA; BBB; AAA, BBB.
Is there a way around this problem? So Excel could identify this data as simply AAA or BBB (to check if the cell contains a given type of transaction separated by a comma?