Forum Discussion
Column not summarized
Hey Anonymous ,
The date which you are using in the matrix/table(calender dimension table);It contains first day of each month.
This is your date dimension table.
It gives all date when you select the date from anacle table instead of calender dimension table.
desired result,when you select date from the anacle table.
If your problem is solved please accept this as solution.
Thank you.
Hey Anonymous ,
The date which you are using in the matrix/table(calender dimension table);It contains first day of each month.
This is your date dimension table.
It gives all date when you select the date from anacle table instead of calender dimension table.
desired result,when you select date from the anacle table.
If your problem is solved please accept this as solution.
Thank you.
Hi Ajinkya,
Thanks for replying, for the date field in anacle column, i do not have a hierachy, i wanted to be able to sort it in years and months, do i have to create new columns? But that defeats the purpose of having the calendar table isnt it?
I do not want the calendar table dates to be just first day of each month, i input it as 1 Jan in excel data table because i cant remove the 1st to represent the whole month, how do i make it have all range?
Thanks and Regards,
VanCe