# New to QlikView

Discussion board where members can get started with QlikView.

Honored Contributor 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
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
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

Valued Contributor III

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

Hi Wizard,

Check in the presentation tab.

Honored Contributor II

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

Hi,

I am using PIVOT table, need Average.

Valued Contributor 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
Honored Contributor II

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

Not working.

Valued Contributor III

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

No Sure if you need this.

See attached.

Not applicable

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

Hi Qlikviewwizard,

try this

Honored Contributor II

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

Valued Contributor 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))))