Average Total for all rows

[qlikview979]

Hi Experts,

For your reference i am attaching snapshot.

Here i want show them the total average(95.3) in all rows.which is showing in snapshot with black mark.

My expression is

Count(DISTINCT UNIX_ID_GOV)/

Count(DISTINCT total UNIX_ID_RST)

Expected Output:-

theresaa‌

Regards

Mahesh

[jubarrosor]

Hi:

Could you attached the source file?

[Lauri]

95.3 is the average of the averages, whereas Sunny's solution gets you the true average of the data across all months. If you set the 'Totals function' in your table to Auto (instead of Avg), you'll probably get 88.8 at the top of your table.