Hierarchical 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
Hello Majeed,
You can invert the order of sales in field section. So that your formula will work.
Hello Majeed,
Could you please share the screenshot of the visual along with the fields?
Hello –
I have the same issue and am struggling to find the “field” section where I can rearrange the columns.