I want to pass Week/Year/FinancialYear/etc... instead of Date in the attached pivot table. I tried to create a group by adding Week(Date), Year(Date),etc in that group and passed the created group instead of Date but it didn't work.
It's not working, because of your expression. When you switch to weeks, years, etc. anything that includes more that one dates, will result in multiple records within one set of dimension values and therefore you need an aggregation function in order to accommodate these multiple records so that you end up with 1 value. In this case a simple SUM around your expression will do it. Check the attached file.
It's not working, because of your expression. When you switch to weeks, years, etc. anything that includes more that one dates, will result in multiple records within one set of dimension values and therefore you need an aggregation function in order to accommodate these multiple records so that you end up with 1 value. In this case a simple SUM around your expression will do it. Check the attached file.
In the sample application which you have provided the solution above. If I add MonthName(date) in the group chart are displayed as shown in the figure. I don't want that to display the something like "##'. I think that is because of less to display the data. Could you please tell me how that could be resolved. I am sorry if it is very simple. But please do let me know how to solve that issue. Please do it only when you are free.
Please make sure that it should not display "##" any more for what ever the time line pass in the group.
