Have day and month in same table

[#1]

Hi !!

See the attached file

I want to have in a same table 2 cols with the sum of day and sum of month like it :

___________________________

| | 03/03/2009 | 03/2009 |

| Sum | 4 | 8 |

I don't know how do for have this 2 dimensions in a same table...

Tks for your help

[antose]

Hi!

Try to add Month as a dimension, see example.

Regards Anders

[#3]

Sorry but it's not what I want

See new attached file

If I choose 01/04/2009 i want this

________________

| | 01/04/2009 | April 2009 |

| | 16 | 30 |

You see the difference ? I want the sum of the month of the date choose in a other column

Sorry for my bad english 😉

[#4]

Hi,

Check the attachment. i believe that should help you.

Regards

Sridhar

[#5]

It's not exatly what I want but I'm going to do with... 😉

Tks

[#6]

ho.... was my understanding is wrong....?[:'(]

ok.. no probs.. can u explain me the scenario elaborately so tat i can break my head further...?

- Sridhar

[#7]

OK

I'm going to explain my case and what I want

I have a first table INVOICE with each invoice (1 invoice = 1 record). In this record I have 4 fields (invoice n°/date/state/turnover/gross margin)

I have a second table CALENDAR with each day (1 day = 1 record) from 1/1/2006 to 1/1/2010 with a lot of fields like name of day, name of month

In a same grid I want see the sum of turnover and gross margin for one day and the sum of turnover and gross margin for the month of this day....

you understand ?

[Oleg_Troyansky]

I think you can do it with 1 Dimension (Day) and 5 Expressions:

- Daily sum(Turnover)

- Daily sum(Margin)

- Month(Day) as an expression

- sum(Turnover) with the Set Analysis modified that will limit the data to the Month(Day)

- sum(Margin) with the Set Analysis modified that will limit the data to the Month(Day)

You might have to define an "island" Date field to enable this logic to work...

Oleg

[#9]

OK tks for your help 😉