I have one requirement. I have one table which contains Year,Half Year, Type,Amount.
Here i need to view data as $(Dollar) and %(Percentage).
For this i have created two buttons. If i click on $ values should be devided by 60 and if i
click on % value should be devided by Gross (one of 'Type' value).
But here i need to display % as 100% in both years.
Ex : For 2014 year Gross is 2200.
so % should be 2200/2200 = 100% for Gross, 850/2200 = 38.6% for Disc,1350/2200 = 61.4% for NonDisc
But i am getting values as 2200/3300(2014+2015 Gross Sum) = 100% for Gross,850/3300 = 25.8% for Disc,1350/3300 = 40.9% for NonDisc.
If i drill down to half year then Gross % should be 100% for all Half Years means it should consider Gross amount for particular Half year but not total Gross.
I am attaching sample QVW also here. Could you please somebody help me here.
when I look at your chart by year, the dollar amount for gross shows 36.7 for 2014 and 18.3 for 2015 but the actual dollar amounts are 2200 and 1100 respecitively
If I click on %, it converst each each year by type to a percent and the Gross is the only one that adds up to 100% across the years
If I create a list box with the period dimension and select 2014, the percentage for 2014 is the same as it was for both years, it just shows 2014. When I click on the % option, it convertes to correct percent
also for 2015, you have gross of 100 but a discount of 2250, which would make your % of discount grreater than 100% - non-discount is the same - shouldnt discount and non-discount add up to gross
