Calculate the percentage per month with totals per column

[david_roble]

Hello,

I'm trying to see % of sales per month in a pivot table, but I can not find a way to calculate % per month without having to filter.

Right now I have:

Team	Jan. 2016	Feb.2016
Team 1	2760	3002
Team 2	424	686
Team 3	411	321
Total	3595	4009

I would be interested to know, if by some formula, I can add a new column, where it tells me the% of each team, since the ALL or TOTAL formulas get me the% of the sum of all the months.

The columns are made with the formula Monthname, of a field type DD / MM / YYYY hh: mm

Thank you

[marcelviegas]

sum(valor)/sum(total valor)

[david_roble]

This formula in the pivot table, caluclate the % from all months

I need the percentage for month

This formula work in only 1 month selected

Thanks

[marcelviegas]

try.

sum(valor)/aggr(sum(total valor),month)

[david_roble]

How select the "Total valor"?

In a pivot table the totals valors is a automatic.. and i dont know select one total in the pivot table

Months in the table are =monthname(date), in you formula would be:

sum(valor)/aggr(sum(total valor),monthname(date))  ?

Thanks!

[david_roble]

Work! but only show in one cell:

I use:

SUM(aggr(Count(Valor),[Month]))

I see:

                      Jan.2016

Team 1     2760    /  3595

Team 2       424    /        0

Team 3       411    /         0

[sunny_talwar]

Try this

Aggr(NODISTINCT Count(Valor), [Month])