Percentage of first value in comparative analysis

[#1]

HI

Ive got a number of parameters which change over a period of time

I'm doing a comparative analysis piece which works well and can get this working fine using the following as an expression

= sum({[Group A] * $}comp.Members)

but what id like to do is visualise it as a percentage change from the first value in the selection.

I have a date column surprisingly  'Date'

so I think somewhere in the statement id need to use

min ({$} Date)

so my final percent calculation would be something like :-

= (sum({[Group A] * $}comp.Members)    /   sum({[Group A] * min({$}Date) }comp.Members)) * 100

but this is clearly wrong , any help guys ?

[Gysbert_Wassenaar]

Maybe this:

= (sum({[Group A] * $}comp.Members)    /   sum({[Group A] * $<Date={'$(=min(Date))'}>}comp.Members)) * 100

I wouldn't be surprised if it doesn't work though. In that case please post a example document with some sample data and what the outcome of the calculation should be.

[#3]

Hi,

Go to Properties->Number tab->and select fixed to and Specify decimal places and click on percentage

but the problem in data then post your sample like wasswnaar  told