Solving for Totals in Merged Tile

[Alex_Binette]

Hi everyone, I hope this hasn’t been solved already but I have a merged tile and I was hoping to be able to sum the in stock field in my example and divide it by the row count for each specific date (transaction week)

I read that you can’t get totals for pivoted merged tiles so I was hoping there was a solution for my problem

I want to be able to show a summary of in stock for each of the dates without listing all of the items

Is this possible?

Thanks