Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am really struggling with creating a stacked 100% bar chart.. Here is what my data looks like. I am creating Lender and County as dimensions and MarketShare as my measure. I am choosing the bar chart option . As you can see from the image, I am not getting the 100% like my data.
Lender | County | Sales | MarketShare |
Guild | Riverside | 39541251 | 0.08% |
Guild | Los Angeles | 81316568 | 0.16% |
Guild | San Bernardino | 11167727 | 0.02% |
All Others | Orange | 23696125 | 0.05% |
Guild | San Diego | 137930978 | 0.27% |
All Others | Riverside | 5166625729 | 10.01% |
Guild | Los Angeles | 23572402165 | 45.66% |
All Others | San Bernardino | 3795186410 | 7.35% |
Guild | Orange | 9762085266 | 18.91% |
All Others | San Diego | 9034103620 | 17.50% |
100.00% |
Try this (like I said to calculate the percentage)
Sum(Sales)/Sum(TOTAL <Lender> Sales)
Hi,
Can you explain more your requeriment?
Canyou also upload a simple data for that?
TX
EC
What is the expression you are using? Assuming it is Sum(Sales), try this:
Sum(Sales)/Sum(TOTAL <Lender> Sales)
I am loading the data exactly as in the post. My measurement then is simply SUM(Sales).
I have a single lender with sales per county plus All Other lenders with sales per county. I want to see what percentage each lender has per county like the example I created in Excel.
Try this (like I said to calculate the percentage)
Sum(Sales)/Sum(TOTAL <Lender> Sales)
Use expression writted by Sunny T
Thanks to you both. Works perfect!