2 Replies Latest reply on Jul 24, 2015 12:15 AM by Tableau kumar

# one measure as a percentage of another measure

Measure Names field has been placed on column shelf and i have text table as below

Measure1    Measure2     Measure 3

Dimension             10             20                30

I want to calculate percentage as : 10/(10+20+30) , 20/(10+20+30)  , 30/(10+20+30)

Please tell me how to do that

result expected as below

Measure1    Measure2     Measure 3

Dimension           in   %              in%         in %

• ###### 1. Re: one measure as a percentage of another measure

Would this not be where you calculate a total as sum(measure1) + sum(measure2) + sum(measure3).

and then create calculations of Measure1%ofTotal = sum(measure1) / total

measure2%ofTotal = sum(measure2)/total

etc?

• ###### 2. Re: one measure as a percentage of another measure

Hi,

Create 3 Calculated Fields as per your explanation in the Question's post.

Then add those 3 & Dimensions to the view.

EX:

1) Name: Total

Syntax: sum([Sales]) + sum([Orders]) + Sum([Return_Amount])

2)

Name: Sales%

Syntax: sum([Sales])/ [Total]

Note: Total is the Calculation which was created in the first Step.

3)

Name: Orders%

Syntax: sum([Sales])/ [Total]])

4)

Name:Return_Amount%

Syntax: sum([Return_Amount])/ [Total]])