Louis_Guionneau
New Member
- Joined
- Nov 12, 2019
- Messages
- 28
Hi everyone,
I'm new to this forum but have spent a lot of time reading through other's posts, which are often very helpful. I haven't found a definitive answer to the following question and hoping you all might be able to provide some guidance. I am pretty new to Power Pivot - thank you in advance for your patience.
I am trying to conduct same store sales on a database that looks like the below (as an example). Is it possible to set up a single measure (without using calculated columns) which could then be leveraged in a pivot table to do year over sales increases for a given filter (e.g. by name, year)?
Thank you so much!
Louis
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I'm new to this forum but have spent a lot of time reading through other's posts, which are often very helpful. I haven't found a definitive answer to the following question and hoping you all might be able to provide some guidance. I am pretty new to Power Pivot - thank you in advance for your patience.
I am trying to conduct same store sales on a database that looks like the below (as an example). Is it possible to set up a single measure (without using calculated columns) which could then be leveraged in a pivot table to do year over sales increases for a given filter (e.g. by name, year)?
Thank you so much!
Louis
Name | Year | Sales |
A | 2010 | 5 |
A | 2011 | 6 |
A | 2012 | 7 |
B | 2010 | 6 |
B | 2011 | 7 |
B | 2012 | 8 |
C | 2010 | 7 |
C | 2011 | 8 |
C | 2012 | 9 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>