This is probably a silly question, and could certainly be done with arrays but here goes.
Is there a way to return in a pivot a view which compares the sum total of a one column to the sum total of another - with a parent / child relationship.
eg. grossly simplified, I have a data table with 4 key fields that I need to present.
Col A = Functional Group (eg. tech, ops, finance, etc)
Col B = Region (eg. Europe, Asia, etc)
Col C = Country (eg. England, France, Spain, etc)
Col D = $s
I'm interested in a view whereby the user can select the country and then see the $s and proportion of the country vs the region vs the global total.
eg. if the user selects Italy, they'll see something like this:
Functional Group Global Europe Italy % Global % Region
Tech 100 50 10 10% 20%
etc
If they were to select Hong Kong, then they'd see the following headings
Functional Group / Global / Asia / Hongkong / % Global / % Region
I could be barking up the wrong tree, but any thoughts would be helpful..
much appreciated
Is there a way to return in a pivot a view which compares the sum total of a one column to the sum total of another - with a parent / child relationship.
eg. grossly simplified, I have a data table with 4 key fields that I need to present.
Col A = Functional Group (eg. tech, ops, finance, etc)
Col B = Region (eg. Europe, Asia, etc)
Col C = Country (eg. England, France, Spain, etc)
Col D = $s
I'm interested in a view whereby the user can select the country and then see the $s and proportion of the country vs the region vs the global total.
eg. if the user selects Italy, they'll see something like this:
Functional Group Global Europe Italy % Global % Region
Tech 100 50 10 10% 20%
etc
If they were to select Hong Kong, then they'd see the following headings
Functional Group / Global / Asia / Hongkong / % Global / % Region
I could be barking up the wrong tree, but any thoughts would be helpful..
much appreciated