I am creating a Matrix where I have as a rows the name of my customers, and then on the columns I have a count of vehicle deviation based on three main categories (mileage, energy, speed).
Basically I want to show for every customer and category, how many vehicles are in red, yellow and green zone. This is done through calculated columns, where I count the number of vehicles for every category.
The thing is that I would be able to drillthorugh by column, and not only for customer (rows), if that makes sense?
This is an exemple, so that the users could right click on a certaing column and it would lead to the drillthrough page, I would have one for each big category (energy, mileage and speed).