Additional summary rows on a QlikView table

[#1]

Hi, I'm new to QlikView.

I built a table with daily total orders received and shipped by day for the selected month.

A summary row automatically appears and provides totals for the month.

I want to add a second summary row with Averages right below the totals.

How does one create an additional summary row that aligns to the rest of the table?

Thank you for taking the time.

[vcanale]

Hi James,
I'm not sure if it's possible to add an additional raw in the table, but you can choose in the Chart Properties to have the Average instead of the Sum.. See printscreen:

Or if you need both or more you can have a look at the Statistic Box and see if it's suitable for your needs.

Hope this can help

Regards

[sunny_talwar]

You can use Pick(Match()) with an Island table or you can use a synthetic dimension to do this.

Look at something similar done here (for a chart, but can be done for a table as well): Re: Subtotals and multiple dimensions in a barchart

[#4]

Hi Sunny,

Thank you for the insight. I will give this a try.

[Amir_h_Aghajani]

Thank you. The answer was clever. You saved my time. I was thinking to switch to SSRS.