I am sorry I didn’t plan to frustrate anyone, specially not people from the forum who are always willing to help, specially to a newbie in sql like me. I...

but if i create the date table dont i have to add the dates manually?

to calculate the first period i go

select sum(Count) from #table where recordday >= '2008-01-01' and recordday...

Chris that but I need to add each row manually which I didn’t want to do (this is the one thing I know how to do lol.

Jayanth, I know more...

it can be something like

Set Count

1st set 87

2nd set 83

and so on..

the table looks bad, i am sorry, i need to check the link you gave me :unsure:

but basically i have dates and a count.

i need to sum the count of...

ohhh.. here is the table, i need to sum the count (this is part of the table as the data goes forever and ever with the dates...)

day ...

thanks!!! what i meant is that i was going to try to understand lol.

but i did on my own before reading my explanation... (there goes my ego :-D)

i am just...

it worked!!!!! 😀

thanks so much!

i just need to understand what you did!

thanks again 😀

yes it is, i just double checked it.

maybe it has to do with the fact that i am formatting the dynamic date of the chb even though i dont need...

i tried that already and nop, doesnt work.

it doesnt the calculation but it doesnt bring the results, that is why i tried to go with the crossjoin.

i get '#Error'

:unsure: well...

the strtomember worked perfectly when i changed the date with the dynamic date (someone pointed that out for me).

the problem that i encounter with that was when i needed to...

thanks to both of you...

i will check the calculated members.

i know i can add the dynamic time on sql (that one i actually know how to do lol), but...

i will try it. thanks a bunch 🙂

it didnt work :w00t:

life on mdx land is never easy 😀

thanks!

the second question was if i want different dates on different columns.

first column yesterday, the second column the day before yesterday, etc etc.

🙂