I got the following difficulty and I was hoping you guys could help me:
I need to create a P&L-like report and the data is like this:
Month
Year
Product
Brand
Region
ProductFamily
Volume
Revenue
Cost
Mkt Expenses
01
2020
ItemA
ABC
North
Beverage
1000
1000
800
30
02
2020
ItemB
CFD
South
Snack
50
70
40
4
From my research, I have to do a crosstable so that I can have the column header as row headers and be able to use on the P&L visual.
It jumped from 214k lines to 19million, but I guess it's unavoidable.
The main challenge now is how would I go about adding a conditional column so the user can click on a category and have it expand on a row level. I guess at editor level, it could this column's categories could even be static:
