
1. Re: % Denominater Constant value
Ashish Chaudhari Jul 26, 2016 2:58 AM (in response to Eshwar Prasad)Hi Eshwar,
Update your code for % Sales to this
SUM([Sales])/ SUM({ FIXED : SUM([Sales]) })
Refer the screenshot. I have unchecked the Appliances SubCategory and Result is still the same.
Also find the attached .twbx for the same. (9.3)
Thanks and Regards,
Ashish Chaudhari

% Constant Denominator value.twbx 1,013.2 KB


2. Re: % Denominater Constant value
Eshwar Prasad Jul 26, 2016 3:14 AM (in response to Ashish Chaudhari)Thanks for the reply ashish..
But The tile is not reflecting the same..
As i mentioned " Means if i selected only two categories, then sum(sales ) of those two selected categories / Total (sum(Sales)). Like this the functionally should work in the Title"
is not working..
if i selected two categories like below
Appliances=1,412,380
Labels=71,416
I need to exclude category "Paper" amount from numerator but that should be included in Denominator..
then Numerator should like = 1,412,380+ 71,416
Denominator= 30,434,456
SO in the title it should be like 4.87% should come@

% Constant Denominator value.twbx 1,022.8 KB


3. Re: % Denominater Constant value
Ashish Chaudhari Jul 26, 2016 3:27 AM (in response to Eshwar Prasad)You have changed the workbook plus added the condition for category <> paper then how it would match.
Ashish

4. Re: % Denominater Constant value
Ashish Chaudhari Jul 26, 2016 3:31 AM (in response to Eshwar Prasad)as per values suggested by you were
if i selected two categories like below
Appliances=1,412,380
Labels=71,416
I need to exclude category "Paper" amount from numerator but that should be included in Denominator..
then Numerator should like = 1,412,380+ 71,416
but you calc are matching with my numbers. Which are the values that you are referring to?
Ashish

5. Re: % Denominater Constant value
Eshwar Prasad Jul 26, 2016 3:37 AM (in response to Ashish Chaudhari)all other are same Ashish. Only one exclusion condition will be there
just need to exclude one category. IN the Numarator amount this category should not be included but in the Denominator we shuld add all the amount.
Amount will be same for all other categories. if you select all then Numarator amount will change to denominator...
Can you please tel the solution for title ..

6. Re: % Denominater Constant value
Ashish Chaudhari Jul 26, 2016 3:46 AM (in response to Eshwar Prasad)Looking into the same.
Ashish

7. Re: % Denominater Constant value
Eshwar Prasad Jul 26, 2016 4:10 AM (in response to Ashish Chaudhari)I Hope you understood the Requirement clearly..

8. Re: % Denominater Constant value
Ashish Chaudhari Jul 26, 2016 4:10 AM (in response to Ashish Chaudhari)Hi Eshwar,
I have used two calcs. 1st one will be used on the charts and second one on the sheet header.
1. AVG({ FIXED [Category]: SUM(if [Category]<>'Paper' then ([Sales]) END)}) / SUM({ FIXED : SUM([Sales]) })
2. (AVG({ EXCLUDE [Category]: SUM(if [Category]<>'Paper' then ([Sales]) END)})/ AVG({ FIXED : SUM([Sales]) }))
Please refer to the screenshot below. (Kindly Note that Sales for Appliances is  $1520047 and for Label is  $74290). I have just excluded the paper category which doesn't change the sales for other category.
Please find the attached for the same.
% calc for Header is calculated as  $1520047 + $74290 = $1594337
and Total sales = $30434456
which is $1594337/ $30434456 = 5.24%
Thanks and Regards,
Ashish Chaudhari

% Constant Denominator value.twbx 596.6 KB
