11 Replies Latest reply on Jun 25, 2018 9:53 AM by Deepak Rai

# Row level calculation

Could you please suggest me how to perform calculation from two rows in the same dimensions.

If we take a example of Super Store.

i want to calculate Sales percentage of dimensions (Segment) sales amount.

 Segment Measure Values Home Office 429,653.15 Corporate 706,146.37 Consumer 1,161,401.34 My Requirment   (Calculation) Home   Office/Corporate 60.84% Corporate/Consumer 60.80%

• ###### 1. Re: Row level calculation

Hi Vikram,

create a calculated field.

sum([sales])/ window_sum(sum([sales]))

Use this calculation in the view.

~Tushar

• ###### 2. Re: Row level calculation

What is the Caculation , Vikram?

• ###### 3. Re: Row level calculation

Thanks Tushar,

I got your calculation but my requirement is like i need contribution of

Home Office/Corporate  (429653/706146) so my result should be 60.84%.

Hope i am able to explain my requirement.

• ###### 4. Re: Row level calculation

Hello Deepak,

My project requirement is :

Contribution of

Home Office/Corporate  (429653/706146) so my result should be 60.84%.

(Example of Sample - Superstore)

• ###### 5. Re: Row level calculation

Here It Is

Thanks

Deepak

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

• ###### 6. Re: Row level calculation

Refind it More

• ###### 7. Re: Row level calculation

Hello Deepak,

Could you please attach again else can you please explain me how to make the "Calculation1" as mentioned in the above print screen.

I use 10.1 version in my office.

• ###### 8. Re: Row level calculation

Ok i will downfrade and reattach

• ###### 9. Re: Row level calculation

Hi Vikram

Here it is attached

Thanks

Deepak

If it Helps, pl mark it Helpful and CORRECT to close Thread

1 of 1 people found this helpful
• ###### 10. Re: Row level calculation

Thanks A lot Deepak,

This will help me a lot in my Business project.

Thanks again

Vikram

• ###### 11. Re: Row level calculation