Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
You can use the above() function to calculate these values. For example sum(amount)/above(sum(amount))-1. Replace sum(amount) with your expressions.
Please Can you send me the Qvw based on my example cause it didn't work .
Thanks alot!!
Hey Ali Please check if You can help Thanks alot:)