Hi Everyone,

First of all, my very best wishes for the new year !
I was wondering of anybody can help me out with following question:

We have an employee dimension with lots of HR related information for each of those employees (surname - last name - ...).
So I want to create a report that shows all different nationalities (so attribute "Nationality ") within my dataset.

Also, I want to count how many times each nationality occurs in my dataset.

I tried the "Hfilter function", but without any luck.

Many thanks for looking into this.

Kind regards,

Gerry

Hi,

Many thanks already for looking into this but the view I am looking for is showing the different types of elements and how many times they occur in that dataset.

In Excel we would call this a pivot table.

Any idea's?

Kind regards.

Gerry