Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table which contains multiple weeks of data. Is there a way I can have the totals show the inventory for just a single week of interest (the current week, the earliest week, something like that)?
The sample table below would have something like 3 weeks of data, but I only want the total to show 1 week's figures. Is this even possible?
Store | Inventory |
1 | 50 |
2 | 20 |
3 | 10 |
Total | 80 |
Hi Eaphy, Dimensionality() returns the number of dimensions in the actual row, so you can use this to set a different expression:
If(Dimensionality()=0, Sum({<Week={$(=Max (Week))}>} Inventory) //Total Row; Set analysis is only an example
, Sum(Inventory)) // Other rows