8 Replies Latest reply: Feb 7, 2013 11:38 AM by Gnana M

# Dynamic % of Total in Trend

Hi All,

I’ve a trend report which is year month wise trended in pivot chart , Where I’ve two dimensions – Country and year month . For each month ,I need to calculate the current month sales / total of current month sales . Also based on year month filter selection the trend should vary but each month I need a total should be 100 .

I’ve tried with sum(sales)/sum(total sales) but its not working out.

sum(total sales) should varying but I need this to be specific for that month and hence only I can get the total as 100. Could anyone please help me how to aggregate ?

 Sales Country 201201 A 1000 B 2000 C 3000 D 4000 Total 10000

 Sum(Sales)/Sum(total sales) % of total Country 201201 201202 201203 201204 A 10 B 20 C 30 D 40 Total 100

Thanks,

• ###### Re: Dynamic % of Total in Trend

Thank you.

• ###### Re: Dynamic % of Total in Trend

any suggestion ?

• ###### Re: Dynamic % of Total in Trend

Can you please attach a sample app with the required Output ..

I could not understand the exact OutPut that is expected from the above Post..

• ###### Re: Dynamic % of Total in Trend

Hi ,

I've attached the application . Thanks .

• ###### Re: Dynamic % of Total in Trend

Hi ,

Hope it helps you..

• ###### Re: Dynamic % of Total in Trend

hi

tab:

Country,

sales

FROM

C:\Users\vishwaranjan\Desktop\Sales.xlsx

(ooxml, embedded labels, table is Sheet1);

Generic LOAD Country, [year/Month],sales    Resident tab;

then take pivote table

dimension-      country

expression1-     Sum( [201201])

expression2-     Sum(([201201]*100) / 7000)

expression3-     sum([201202])

expression4-     Sum(([201202]*100) / 10000)

and presentation select country check on partial sum

then output like this

 Country 201201 % Total of 201201 201202 % Total of 201202 A 1000 14.29 7000 70 B 2000 28.57 1000 10 C 4000 57.14 2000 20 Total 7000 100.00 10000 100
• ###### Re: Dynamic % of Total in Trend

hii see the attached file