Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Has anyone got the problem with TOTAL <> with an autocalendar dimension?
I have a DateCode dimension (such as: 2018-01-01 : YYYY-MM-DD), a dimension of product (such as: ProductA, ProductB).
I have a fact table with sale of each product in a period of time.
Then, I created a line chart with:
- Group Dimension is DateCode
- Line Dimension is Product
- Measure is: sum(sales) / sum(total <DateCode> sales)
I got a chart with % of sale of each product on total sale of each day. It works perfectly.
Then, I modify it to get the same chart with Month/Quarter, but I cannot handle it to work:
This is how I try:
- Group Dimension: DateCode.autoCalendar.YearMonth
- Line Dimension is Product
- Measure is: sum(sales) / sum(total <DateCode.autoCalendar.YearMonth> sales)
What I get is % of sale of Product on whole sale regardless of datecode,month. While I expected to get the % sale of product all total sale of each YearMonth.
Could anyone show me what I did wrong?
Additionally, I tried with some original dimension instead of DateCode, it works as my guest, just with the dimension include autocalendar, the total keywork seems doesn't work.
Thanks so much for any help.
Instead of using DateCode.autoCalendar.YearMonth, I manage the dateCode to get YearMonth in the dataloadeditor and use this new field as the dimension (of course in the expression TOtal <newField>) , it works well. Therefore, I think the problem is an issue of autoCalendar
Are you using YearMonth as your dimension too?
How are you expecting to calculate sum(Sales) YearMonth Wise?
It looks fine, can you share some sample data to check?
I attached a dummy data
Instead of using DateCode.autoCalendar.YearMonth, I manage the dateCode to get YearMonth in the dataloadeditor and use this new field as the dimension (of course in the expression TOtal <newField>) , it works well. Therefore, I think the problem is an issue of autoCalendar
Perfect 🙂