Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
I am stuck in the issue when i need to count on date values, and i am getting 0 instead of correct numbers.
I have table like this
Week | Age |
2/4/2015 | 0-30 |
2/4/2015 | 0-30 |
2/4/2015 | 31-60 |
2/4/2015 | 61-90 |
2/4/2015 | 90+ |
2/11/2015 | 0-30 |
2/11/2015 | 31-60 |
2/11/2015 | 31-60 |
2/11/2015 | 61-90 |
2/11/2015 | 90+ |
3/11/2015 | 0-30 |
3/11/2015 | 31-60 |
3/11/2015 | 61-90 |
3/11/2015 | 61-90 |
3/11/2015 | 90+ |
I need a pivot table like this
Age | 2/4/2015 | 2/11/2015 | 3/11/2015 |
0-30 | 2 | 1 | 1 |
31-60 | 1 | 2 | 1 |
61-90 | 1 | 1 | 2 |
90+ | 1 | 1 | 1 |
For this,
i was taking one dimension Age and conditions on expressions like
Count({<[Week] = {'2/4/2015'}>}[Week])
which is returning 0.
Can you please help me on this?
Regards,
Kuldeep
Example attached
andy
Hey Andrew,
This is perfecto!
Thank you so much
Regards,
Kuldeep