1 2 Previous Next 22 Replies Latest reply on Dec 7, 2017 9:28 AM by Shinichiro Murakami Go to original post
• ###### 15. Re: Making parameter that will change chart label

Hi Kemal,

Thank you!

Would you be so kind to clarify should this formula use WINDOW_SUM???

Dimitriy

• ###### 16. Re: Making parameter that will change chart label

Hi Kemal,

Sorry to say but the formula is not working again... =(

• ###### 17. Re: Making parameter that will change chart label

Your total cost: 1.352.012.118

Brand 392 Cost (Value in the first bar of graph): 16.581.875

So divided result must be 0.0123. Let me know If you were different kind of % of total. I did not understand your question about window_sum. Do you wish to achieve this result by using window_sum instead of Fixed?

• ###### 18. Re: Making parameter that will change chart label

1,23% is not the corresponding value=( The percent should be taken by brand from total of Month or Quarter. Total for Jan 2013 is 22 M so Brand 392 which have 3.4 should have percent corresponding to total 22M.

• ###### 19. Re: Making parameter that will change chart label

Here it is:

SUM([Selected_Measure])/SUM({ FIXED [Year_Month]:SUM([Selected_Measure])})

• ###### 20. Re: Making parameter that will change chart label

Still not working =(

• ###### 21. Re: Making parameter that will change chart label

The 'other' group is calculated incorrectly....

• ###### 22. Re: Making parameter that will change chart label

HI Dimitriy

I lost the track of each individual change, but I add label one on top of Rank file because it's much easier to handle.

Because you said the rank should change every period, put Brand- Period in detail shelf.

And set all the table calc seetting as below.

Regards,

Shin

1 2 Previous Next