Hi,
I have a pivot table where:
rows: Stores, Week
columns: Year (2013, 2014)
values: Sales
This essentially displays Sales by store and week for 2013 and 2014
I then put another Sales variable in to values, calculated a % Difference from Year 2013 as "YoY Change"
My ultimate goal is to be able to filter on YoY Change value to show rows where YoY Change is down 5% (< -5%).
When I try Value Filters [YoY Change 'is less than' -5% ] the pivot table returns no records.
I was thinking this is because "YoY change" is not an actual field in the data and Excel is doing some weird calculation on the filter?
I was thinking of creating an actual calculated field for YoY Change, but not sure if that will work and not entirely sure how to create the formula to mirror % Difference from Year 2013 - any ideas here?
Or is there a better way?
Any help in solving this problem is appreciated, thank you!
I have a pivot table where:
rows: Stores, Week
columns: Year (2013, 2014)
values: Sales
This essentially displays Sales by store and week for 2013 and 2014
I then put another Sales variable in to values, calculated a % Difference from Year 2013 as "YoY Change"
My ultimate goal is to be able to filter on YoY Change value to show rows where YoY Change is down 5% (< -5%).
When I try Value Filters [YoY Change 'is less than' -5% ] the pivot table returns no records.
I was thinking this is because "YoY change" is not an actual field in the data and Excel is doing some weird calculation on the filter?
I was thinking of creating an actual calculated field for YoY Change, but not sure if that will work and not entirely sure how to create the formula to mirror % Difference from Year 2013 - any ideas here?
Or is there a better way?
Any help in solving this problem is appreciated, thank you!
