Hierarchical Variance Table

1.34K viewsHierarchical Variance table
0

I downloaded the Hierarchical Variance Table but it doesn’t have control over different elements of the visual.

for example i have sales for 2018 = $1000,000

and Sales for 2019 = 1,200,000

this should be increase – but in the table its making it decrease by 200,000, because its calculating as follows(Variance = sales 2018 – sales 2019) and bringing the value in Negative.

I want to change that so i can use the following formula = (Variance = sales 2019- sales 2018), how can i do

Answered question
0

Hello Majeed,

Could you please share the screenshot of the visual along with the fields?

Answered question
0

Hello –

I have the same issue and am struggling to find the “field” section where I can rearrange the columns.

Answered question
0

Hello Majeed,

You can invert the order of sales in field section.  So that your formula will work.

Answered question