Count on Date problem

[#1]

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

[awhitfield · Accepted solution]

Example attached

andy

[#3]

Hey Andrew,

This is perfecto!

Thank you so much

Regards,

Kuldeep