Hi All,
I have created a cross tab with eight character cloumns and one measure(price) .
I need to create an additional measure as subtotal price ratio[ price/subtotal of price within first two column cobination,country/region)
based on the first two character columns(country®ion).I know percent of subtotal option in cross tab;but i want to display subtotal for first two columns only[dont want subtotal for each of the eight column level) and also need to use that to calcualte the price ratio.
In excel, this is pretty much possible, but i cannot doany option to do this in sas va......
Please provide me a solution for this as I am stuck with simple stuff from excel perspective...
Regards,
JG