Set Analysis for Table Totals?

[eaphymaoweave]

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

[rubenmarin]

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