Question

Solving for Totals in Merged Tile

  • 16 August 2020
  • 1 reply
  • 147 views

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


1 reply

Userlevel 2

Hello @Alex_Binette,


I’m a bit confused by your description. A few clarifying questions,



  • You have a dashboard with a tile on it which contains a merge query?

  • You are wanting to create a table calculation in the merge query?


I want make sure I understand the question before confusing you more. 🙂


Kind regards,

–Thomas

Reply