Hello,
I need help writing a formula for excel power pivot table please, that will subtract two calculated items from the same data table column in the pivot area.
The formula will subtract "Past 4 Weeks" from "Prior 4 Weeks" as a calculated item column that will display in Column "D" and apply for all the measures listed (Invoiced, LY Invoiced, Qty).
Data table column name is [Trend 4 Weeks] with two text items: "Past 4 Weeks" and "Prior 4 Weeks".
Can you please assist?
I need help writing a formula for excel power pivot table please, that will subtract two calculated items from the same data table column in the pivot area.
The formula will subtract "Past 4 Weeks" from "Prior 4 Weeks" as a calculated item column that will display in Column "D" and apply for all the measures listed (Invoiced, LY Invoiced, Qty).
Data table column name is [Trend 4 Weeks] with two text items: "Past 4 Weeks" and "Prior 4 Weeks".
Can you please assist?
