Growth in Expression

[mario-sarkis]

example of Growth

Date          Volume-Sub-Categories     Volume-Categories    Volume-CategorieFlag

Dec-12      200                                           500                              1000     
Dec-13      300                                           600                              1200   

Dec-14      400                                           800                              1600

the Growth Shows in a line Chart will be calculated as:

Date          Volume-Sub-Categories     Volume-Categories    Volume-CategorieFlag

Dec-13       (300-200)/200                      (600-500)/500             (1200-1000)/1000

Dec-14       (400-300)/300                      (800-600)/600             (1600-1200)/1600

My dimenssions on a line Chart will be :

1-Date

2-GroupFields ( Category Flag >>Category>>Sub-Categories)

Hope this will help More and much clearer then the first example.

Thanks Again,

Please attachement a sample of my current Date in a  QVW file and its source:

[Gysbert_Wassenaar]

You can use the above() function to calculate these values. For example sum(amount)/above(sum(amount))-1. Replace sum(amount) with your expressions.

[mario-sarkis]

Please Can you send me the Qvw based on my example cause it didn't work .

Thanks alot!!

[mario-sarkis]

ali_hijazi

Hey Ali Please check if You can help Thanks alot:)