Ankitsahgal
New Member
- Joined
- Dec 19, 2015
- Messages
- 11
Hello everyone,
I am trying to build a P&L that I can slice and dice as required. I get data for multiple sites and need to ability to into with a few clicks.
I have the data in the below format:
<tbody>
</tbody>
I am trying to calculate the Gross profit which is Drink sales - Drink COS , Food sales -Food COS
I have come up the below:
Cost of Sales:= Calculate([Sum of Period 1],[category]="Drink Sales")-Calculate([Sum of Period 1],[category]="Drink COS")
But obviously I will have to create the same measure for all the periods ?
Is there a way to create a single measure as opposed measures for so many periods?
Thank you
Ankit
I am trying to build a P&L that I can slice and dice as required. I get data for multiple sites and need to ability to into with a few clicks.
I have the data in the below format:
Site Name | Category | Period 1 | Period 2 | Period 2 | Period 3 |
Delta | Drink Sales | 5 | 10 | 15 | 20 |
Delta | Food Sales | 10 | 5 | 7.5 | 15 |
Delta | Drink COS | 2 | 5 | 3 | 9 |
Delta | Food COS | 6 | 1 | 2 | 5 |
Beta | Drink Sales | 6 | 10 | 8 | 11 |
Beta | Food Sales | 8 | 7 | 4 | 6 |
Beta | Drink COS | 3 | 4 | 2 | 1 |
Beta | Food COS | 6 | 4 | 3 | 2 |
<tbody>
</tbody>
I am trying to calculate the Gross profit which is Drink sales - Drink COS , Food sales -Food COS
I have come up the below:
Cost of Sales:= Calculate([Sum of Period 1],[category]="Drink Sales")-Calculate([Sum of Period 1],[category]="Drink COS")
But obviously I will have to create the same measure for all the periods ?
Is there a way to create a single measure as opposed measures for so many periods?
Thank you
Ankit