Please check out the attached file and see if it meets your needs. I have two sheets one for each requirement
Test2.qvw 158.0 K
thanks a lot!
Sheet 2 is perfect - exactly what i wanted. By the way - what exactly do i need to do to turn on those green fields ?
Sheet 1 is not exactly what I'm looking for
Lets take the below example
ID Customer Product Sales 1 A Bat 10 2 A Bike 20 3 A Tire 30 4 B Bat 45 5 B Tire 56 6 B Bike 30 7 C Bat 30 8 C Tire 5
I want to see what % share Tyres have in total sales to customer C (total sales to C customer). Or what % share bat has in tota sales to customer B.
The its 'Text in chart' option. Right click chart > properties > presentation . in the bottom right you can see an add option where you can use your own expressions/texts and whose results will be displayed on the chart as text.
For the first chart is this want you want
ID Customer Product Sales 1 A Bat 10 17% 2 A Bike 20 33% 3 A Tire 30 50% 4 B Bat 45 34% 5 B Tire 56 43% 6 B Bike 30 23% 7 C Bat 30 86% 8 C Tire 5 14%
The first value 17% is calculated by 10/(10+20+30). If so please check out the attached file. I added two dimensions and created a legend for each Product.
Answer.qvw 163.5 K