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.