hi everyone,
i have a power pivot that contains different metrics for every SKU in different dates,
like this:
<tbody>
</tbody>
i want to rearrange this power pivot to reference specific column for every SKU in a week,for example trying to compare the forsalestock of each SKU week over week. like this:
<tbody>
</tbody>
how can i do that? Is there any formula?
thanks in advance.
i have a power pivot that contains different metrics for every SKU in different dates,
like this:
date | SKU ID | color | forsalestock |
2/8/2018 | 293774 | red | 15 |
2/15/2018 | 293774 | orange | 10 |
<tbody>
</tbody>
i want to rearrange this power pivot to reference specific column for every SKU in a week,for example trying to compare the forsalestock of each SKU week over week. like this:
SKU ID | color(week 2/8/2018) | color(week 2/15/2018) | forsalestock(week 2/8/2018) | forsalestock(week 2/15/2018) |
293774 | red | orange | 15 | 10 |
<tbody>
</tbody>
how can i do that? Is there any formula?
thanks in advance.