cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mcmanl01 Frequent Visitor
Frequent Visitor

% Sales Share per Customer Type per Year

Hi,

 

I'm struggling to create a measure that will allow me to display the data in the same format as the picture below

 

 

image.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

each bar shows the percentage sales share for that customer type (plat, gold, bronze, silver) in a given year.

 

All the formulas I've come up with only give me a percentage of the grand total. 

Any help or guidance would be much appreciated!

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: % Sales Share per Customer Type per Year

@mcmanl01 ,

 

Here are two examples.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: % Sales Share per Customer Type per Year

@mcmanl01 ,

 

Here are two examples.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tangutoori Regular Visitor
Regular Visitor

Re: % Sales Share per Customer Type per Year

PLEASE SHARE DATASET