Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello,
Using Crosstable in scripting, you will get the output.
Attaching the qvf and output.
Thanks,
Sonu Sagar
Hello,
Using Crosstable in scripting, you will get the output.
Attaching the qvf and output.
Thanks,
Sonu Sagar
Works perfect,
Thanks a lot for your help!.
Regards,
Jose.