I am trying to create a cross tab report that will be used for bench marking.
The field I am using for bench marking is called share.
I want to display two columns:-
Share by seller vs share by state and category.
So if I were to look at the cross tab report I could see the share for that seller in the state vs the share for all the seller in that state.
How can I display both of these in the same cross tab report?
I don't have very good mock data to depict this scenario but I have tried my best.
I am not sure what exactly is your question. however, I tried to resolve it as much as i understood.
PFA updated benchmark workbook for your reference.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...