Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
In below (and attached QV) I need custom percentage, How this possible please?
Perc = (TotalValue / Mar-2012 (15627.62) )* 100
So for Jan-2012 -> (8891.78/15627.62) * 100 = 56.90% and so on
(Mar-2012 value is denominator always in this case)
I appreciate your help
Thanks
See attached qvw.
You can create a variable that that will calculate March-value and calculate with it.
create a variable vThisMonthValue as:
=Sum({<YearMonth={$(=Only({<Date={Today}>}YearMonth))}>}Value)
then your expression becomes:
Sum(Value)/$(vThisMonthValue)
if you only need to do this for the total column, then play around with:
Dimensionality() and SecondaryDimensionality() and use them in an if:
i.e:
if(Dimensionality()=0 and SecondaryDimensionality() = 1,
sum(Value)/$(vThisMonthValue)
,
sum(Value/SomeOtherValue
)
Hi Gysbert
There is no attachment please.
Thanks
Hi Simen
I appreciate your prompt reply. In my case(attached QV) has only one dimension, And 'Perc' column is aggregated, I need effect in particular this column only.
Thanks for your time and effort