Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to create a straight table using the below columns
District ID
% of growth
expecting straight table
District ID | % of growth |
---|---|
----------------------------------------------------------------
my table
CustomerID | DistrictID | % of growth |
---|---|---|
1 | 1 | 5.2 |
2 | 1 | 4.1 |
3 | 2 | 2.2 |
4 | 2 | 85.2 |
5 | 1 | 47.2 |
6 | 3 | 41.02 |
In each district there are many customers, so how can i get the growth % for each district in straight table?
No idea. Average them perhaps? You'll have to explain how the growth percentages should be aggregated from customer-district level to district level. A growth percentage is usually based on two values. If you have these values you could aggregate those separately using the sum function and then calculate the growth percentage from those sums. That would give you a correct result. Using only the growth percentages that's impossible.
I have columns Current_Year_Amount and Previous_Year_Amount to calculate growth percentages. could you please tell me how to get the result as you said in your reply?
Use District as dimension and as expression sum(Current_Year_Amount)/sum(Previous_Year_Amount) -1. Change the Number format of the expression to Fixed, choose the number of decimals and enable the Percentage option.
Thanks Gysbert.