# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for
Did you mean:
Highlighted
Master II

## Average in place of total in pivot table

Hi All,

How to get the Average in place of total in pivot table.

Required output:

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary

## Re: Average in place of total in pivot table

Hi,

And in Presentation tab Change caption to Average in Labels for Totals text box for both Country and JOB dimension.  PFA for solution.

Regards,

Jagan.

13 Replies
Highlighted
MVP & Luminary

## Re: Average in place of total in pivot table

Within the tab presentation in the top left you could set a total-name for each dimension.

- Marcus

Highlighted
Specialist III

## Re: Average in place of total in pivot table

Hi Wizard,

Check in the presentation tab.

Highlighted
Master II

## Re: Average in place of total in pivot table

Hi,

I am using PIVOT table, need Average.

Highlighted
Specialist III

## Re: Average in place of total in pivot table

I guess by using dimensionality() function  we can achieve this

I guess something like this:

if(dimensionality()=1,RangeMax(0,avg(Slaes)))

but i did not get a chance to implement.

try this and let me know.

Highlighted
Master II

Not working.

Highlighted
Specialist III

## Re: Average in place of total in pivot table

No Sure if you need this.

See attached.

Highlighted
Not applicable

## Re: Average in place of total in pivot table

Hi Qlikviewwizard,

try this

Highlighted
Master II

Highlighted
Specialist III

## Re: Average in place of total in pivot table

I have attached the solution yesterday itself. check out

edit:

use the expression :

If(Dimensionality()=2,

round(Sum(Sales)),

round(avg(aggr(sum(Sales),Country,JOB))))