Dynamic % of Total in Trend

[#1]

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,

[#2]

I really needed your inputs

Thank you.

[#3]

any suggestion ?

[#4]

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..

[#5]

Hi ,

I've attached the application . Thanks .

[#6 · Accepted solution]

Hi ,

Please find the Attached App..

Hope it helps you..

[#7]

hi

tab:

LOAD [year/Month],

     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

[er_mohit]

hii see the attached file

[#9]

Thanks a lot for your suggestions . Spl thanks to Bhaskar