Problems with Month dimension

[#1]

Hi guys,

I have a problem. I have a table that looks like that:

Order id            orderdate        deliverydate

11                        2013.01.01       2013.05.01

12                        2013.01.02       2013.01.29

13                        2013.05.01       2013.05.25

I need to make a chart with month in dimension that would count orders and deliveries in month

I did that:

Month (orderdate) as month

Month (deliverydate) as month

But I get an error while loading data

Any suggestions?

1. Thanks in advance J

[michael_maeuser]

you can´t load 2 fields with the same name.

try s.th. like that

Month (orderdate) as month

Month (deliverydate) as month2

the reason is you can either show your values by orderdate OR by deliverydate. but with example above you can create a cyclic dimension, so that you can switch between both dates

[abeyphilip]

Hi,

Agree with Michael.

May be you can try something like being done in the attached the QVW.

regards,

Abey

[Anonymous]

Hi,

    Hope the attached excel and dashboard file will helpful for you

Regards

Ashok