# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
Creator II

## Average, % of Quota by all dimentions in Pivot Table

Hi frends!

Help me to write right expression to calculate "Quota" value by all dimentions.

Expression I'm using looks like:

```Avg(
Aggr(
Sum ( TOTAL<Collection,Category,Group, Subgroup> Quota )
,Collection,Category,Group, Subgroup)
)

```

I'm using pivot table:

Expression works fine on Subgroups level. But when we drill down to Group, Category and Collection it stops calculate AVG(...) rightly.

For example

Collection: April. If i drill down to Group i've got the next view:

If we look at Categorty: "Одежда (RTW)" and drill down to Category we need to get average "Quota" - 51,33 %.

But what we have:

???? It's wrong.

The same thing with Collection.

How to get average from the last granular lever "Subgroup" for all dimentions "Collection", "Category", "Group" ???

Or how to calculate the average as I wrote for example for Collection "April" and Category "Одежда (RTW)" - 51,33% ???

P.S.: Source .qvw in attachment.

1 Solution

Accepted Solutions
Not applicable

Hi,

Why do you think, you should get 51,33%?

I feel 50, 68 is correct, as average happens within underlying data rather than just summing up 8 cells value and dividing it by 8.

Thanks,

Vinod Kumar V

Not applicable

Hi,

Why do you think, you should get 51,33%?

I feel 50, 68 is correct, as average happens within underlying data rather than just summing up 8 cells value and dividing it by 8.

Thanks,

Vinod Kumar V