Count of Dimension

[#1]

Hi,

How we can count the Dimension Values And Display In Pivote Table

Kindly Have a Look on Attachment

[sunny_talwar · Accepted solution]

This?

[swuehl]

Dimension: Country

1. expression: =Count(Country)

2. expression: =Sum(Sales)

Sales figure differs from what you've posted.

edit:

1. expression: Count(Distinct State)

would probably be more correct

[robert_mika]

Like this?