Calculate percentage

[stephenedberkg]

How to calculate primary sales and secondary sales  variance sales percentage?

below i attach the sample image

[#2]

come up with little bit more

[#3]

Hi,

you can use the formula

put your dimension in dimension tab,

and use the formula

(sum(primarysales)-sum(secondarysales))/sum(primarysales).

If you are not satisfied with the solution.Can you please describe further?

Regards

Harshita Gaur

[stephenedberkg]

Dears,

   i have two table that have an primary sales and secondary sales. I want the variance percentage?

Eg:

if i select the 2014 June mean i want the primary and secondary sales percentage

[vardhancse]

what is the dimension you are looking in to

[jyothish8807]

Hi ,

PFA.Hope it helps.

Regards

KC

[#7]

hi,

it means you have two columns, one represent the primary sales of the respected month, and other represent the secondary sales for that month,

then you can create a chart with month as a dimension and the above formula as a expression.

with regards

harshita gaur

[stephenedberkg]

i didn't add any dimension?

[#9]

Hi,

if you dont want to show it for any dimension, you can go for gauge, and show this percent into it

with regards

Harshita Gaur

[#10]

Hi,

see the attached QVW,

With Regards

Harshita Gaur