Calculation in Pivot table

[spividori]

Hi.

I have to divide each period by the selected, in my example, I have to divide the value of Sep-14 for the value of 14-Feb value, and so with other periods.

The slider object is used for the user to select the number of months you want to analyze from the selected month.

Attached example.

Regards.

Sandro.

[sunny_talwar · Accepted solution]

Try this expression:

1/(sum({<Month={"<=$(=max(Month)) >$(=date(addmonths(max(Month),-$(nMeses)),'MMM YY'))"}>} Indec)/sum(TOTAL{<Month={"=max(Month)"}>} Indec))

Output:

Attaching your sample back for reference

Best,

Sunny

[spividori]

Hi Sunny.

It is working properly. Thank you.

Regards.

Sandro.

[sunny_talwar]

No problem