Hierarchical Variance Table

Solved3.25K viewsHierarchical Variance table

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

Question is closed for new answers.
Selected answer as best

Hello Majeed,

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

Selected answer as best
You are viewing 1 out of 3 answers, click here to view all answers.