Disregard a Dimension in calculation in a Pivot Table

[nancy_sbeity]

Hello,

I really need your help in the following case:

This is an example of my Pivot table:

Item\Category	Category1	Category2
Item1	sum(Sales in Category1 and Item1) / sum(Sales in all the categories and In Item 1)	...
Item2	...	...

So My purpose is to get the sum of sales of each row and column, divided by the sum of sales of the row in all the columns.

I used the following measure: sum(Sales) / sum({1<Category= >}Sales) but I didn't get the right answers.

Any idea?

Thank you in Advance,

Nancy

[sunny_talwar]

Try this:

sum(Sales) / sum(TOTAL <Category> Sales)

[swuehl · Accepted solution]

Sum(Sales) / Sum(TOTAL<Item> Sales)

TOTAL qualifier is essentially telling QV to disregard all dimensions, by adding an optional field list in angle brackets, these fields will still be regarded (and I understand that you still want to regard Item dimension).