Forum Discussion
Calculating Daily Totals based on helper sheets
Hi Anonymous ,
Please have a try.
Create a column.
Column = CALCULATE(MAX('price'[Value]),FILTER('price','price'[Food]=EARLIER(Restaurant[type])))If I misunderstand your meanings, please provide more than two days' data and expected output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionAnonymous please provide some sample data and expected output.
Hi, Let's see..
The below would be a simplified verison of the daily product made for each site, in the final version I would like to input a table with many more rows for each site.
| Restaurant 1 | Coffee | 20/11/2021 |
Restaurant 1 | Cake | 20/11/2021 |
| Restaurant 2 | Coffee | 20/11/2021 |
Restaurant 2 | Cake | 20/11/2021 |
| Restaurant 3 | Coffee | 20/11/2021 |
Restaurant 3 | Cake | 20/11/2021 |
| Restaurant 4 | Coffee | 20/11/2021 |
Restaurant 4 | Cake | 20/11/2021 |
Group List
| Restaurant 1 | Group 1 |
| Restuarant 2 | Group 2 |
| Restaurant 3 | Group 3 |
| Restaurant 4 | Group 1 |
And the price list
| Food | Group 1 | Group 2 | Group 3 | Group 4 |
| Coffee | £1 | £1,20 | £1,10 | £1,30 |
| Cake | £2 | £2,20 | £2,10 | £2,30 |
So I would like to create some chart to show how much each site has made £ each day, based on the group they belong to which determines the price for each item.
I hope this makes sense