Could you please share a sample workbook.
The answer to this will depend on how your data is structured
Filters self: Meaure Names
Rows shelf: Car Type , Measure Names
Marks self: Meaure Values
Say my dataset is as below:
Car Type Sales Profit New 20 10 Used 30 20 Recon 50 20
Also what is your original data source excel, csv , ms sql ?
This is easily achieved if your data is coming from a flat file. Excel or CSV
as you can pivot the measure.
See attached workbook.
let me know if you have any further questions.
Hide Pecific.twbx 16.3 KB