5 Replies Latest reply: Dec 6, 2017 5:58 PM by Luis Madriz

# calculated dimension

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

• ###### Re: calculated dimension

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

• ###### Re: calculated dimension

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?

• ###### Re: calculated dimension

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?

• ###### Re: calculated dimension

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.

• ###### Re: calculated dimension

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