
1. Re: plotting a percentage of a calculated field
Tracy Rodgers Dec 20, 2013 11:11 AM (in response to Imran Akbar)Hi Imran,
Are you able to post the packaged workbook so we can take a closer look?
Tracy

2. Re: plotting a percentage of a calculated field
Imran Akbar Dec 23, 2013 5:50 PM (in response to Tracy Rodgers)Hi Tracy,
Unfortunately the data is proprietary, so I can't post my workbook; but I've attached a screenshot and the calculations I'm doing. I managed to plot what I needed by doing a custom calculation that itself using 4 underlying custom calculations and the values of 2 parameters ('income' and 'retailer Parameter'). What I'd like to do now is plot that custom calculation, but for multiple parameter values  which doesn't seem to be possible using this method.
Here are the 5 calculations I'm doing:
All Sales = SUM([subtotal_implied])
All Sales for Income Group = IIF([dem_income]=[income],[subtotal_implied],0)
All Sales for Retailer = IIF([retailer]=[retailer Parameter],[subtotal_implied],0)
All Sales for Retailer and Income Group = IIF([dem_income]=[income] AND [retailer]=[retailer Parameter],[subtotal_implied],0)
Index = 100*(SUM([All Sales for Retailer and Income Group])/SUM([All Sales for Retailer ]))/(SUM([All Sales for Income Group])/[All Sales])
In the attached screenshot, the Index is displayed in the top row, and is essentially the ratio of the next 2 rows, divided by the ratio of the bottom 2 rows (those rows look similar, but they've all got different scales on the yaxis).
Any suggestions on other ways to accomplish what I'm trying to do?
thanks,
imran