Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a variable vchange which is a percentage calculation and I want to use it as dimension.
how can I do it?
Thanks
Hi,
Usually something like this:
=AGGR(calculation of the percentage,otherdimension)
The field other dimension is what you want differentiates each row
For example, if I need count of patient per hospital as a dimension I'd go:
=AGGR(Count(Patient),Hospital)
If I have 3 hospitals, there will be three rows and each row with the count
I hope this helps,
Luis
so if I have count of locations as measure and I want to use this vchange as dimension in bar chart, and I have other 3 different measures as well then,how can I do it?
I have to say that it's strange to have all those many as dimensions in the same chart but it could be done using similar procedure... maybe you want to explain what you have and the expected outcome?
I need to calculate a percentage value,vChange will give me the percentage value . I have 6 different measures Countt of X, Count of Y,sum (of X+Y),count of A, Count of C and Count Of D.
I do not have specific dimension I want to use this percentage value as alternate dimension in my bar chart.
Hi,
Then you just need all those as measures and you may just create a fake dimension such as ='Total'
I hope this helps,
Luis