Hi,
I am looking to create a pivot table that is able to handle positional inventory dynamically.
For example, if I have 3 weeks in my filtered range, I want to only show the data on the last week.
I am using the below.
CASE
WHEN Week ending date
= MAX(Week ending date
) OVER ()
THEN SUM(ifnull(EOH Qty
,0))
ELSE 0
END
This works if I have all my dimensions in the pivot table.
When I remove elements or weeks I get errors although the totals are correct,
The totals are still correct and even the line level is okay but I am still seeing ### in one row.
If I am only showing store level totals are correct but it isn't summing the values by store.
Anyone ever try to do this?