Count different values over dimensions

[josemaria_cabre]

Hi Everyone,

Let's imagine we have this table, where every dimension can contain different values from 0 to 5:

And we want to get another table, that counts how many times each value appears on corresponding dimension:

How can I get the dimension 'Value'?, and how do I count appereances of each value on this new dimension?

How can I add totals to this table as well?

I tried to do something like 

Count({<Dim1 = {'0'}>} DISTINCT ID)

but this involves creating a different expression for each value and for each dimension.  I'm sure there must be an easier way to achieve my pretending table.

Can anyone help with this? I'm attaching a .qvf file with this example dimensions and values.

Thanks in advance,

Jose.

[sonusagar · Accepted solution]

Hello,

Using Crosstable in scripting, you will get the output.

Attaching the qvf and output.

Thanks,

Sonu Sagar

[josemaria_cabre]

Works perfect,

Thanks a lot for your help!.

Regards,

Jose.