5 Replies Latest reply on Jul 23, 2018 9:37 AM by Deepak Rai

# LOD, running total of % of total... using only specific dimensions

hi, not sure how to tackle this... i have a Dimension with 10 members.  I need to calculate a % of Total but also provide a Running Sum, BUT it is a running sum of specific values..  i created a screenshot of what i need , hopefully you can understand.  the number come in raw (just a sum of the numbers), so I need to calculate a % of Total first, then a running sum, please let me know if you have questions

• ###### 1. Re: LOD, running total of % of total... using only specific dimensions

Jon,

You are here for a while and we do appreciate your contributions here. Would you like to go one more step by creating a Sample Workbook to help you faster?

Thanks

Deepak

• ###### 2. Re: LOD, running total of % of total... using only specific dimensions

your right, sorry.  please refer to original post and screenshot, or post any questions..

• ###### 3. Re: LOD, running total of % of total... using only specific dimensions

Hi Jon,

Here it is:

See the effect of attached workbook.

Please go through the Calculations I used to get the Result

and then I Created a Filter and Hide The Headers from Columns to get Finally here:

Thanks

Deepak

If it Helps, Pl mark it Helpful and CORRECT to Close Thread

• ###### 4. Re: LOD, running total of % of total... using only specific dimensions

Hi Deepak, thanks for the work.  I screenshot I included was just something to help try to explain what the calculations needed.  I am struggling trying to get to my final viz which is the item circled in the screenshot above...  i was thinking an LOD would provide this functionality to just drag SegmentLabel on Rows, Company on Column and LOD calc on text.... possible??

do you think creating 3 different groups then summing each group and dividing with SUM ( If SegmentLabel1 = "Overall")

IF  [INDEX] >= 2 and [INDEX] <=6 then "1+ CPD"

ELSEIF [INDEX] >= 3 and [INDEX] <=6 then "2+ CPD"

ELSEIF [INDEX] >= 4 and [INDEX] <=6 then "3+ CPD"

END

• ###### 5. Re: LOD, running total of % of total... using only specific dimensions

Well I tried that. Only Thing I can Suggest you to use Measure Values and Measure names to get values under one column.

Thanks

Deepak