Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I use set analysis to create “Sum 12 last month amount “ column
When I select one “country” it work good , But when I select corporate
The “Sum 12 last month amount “give me the amount for all the countries and not the
“Sum 12 last month amount” for each “corporate & country” (per row).
Why?
corporate | country | Current month amount | Sum 12 last month amount |
amp | CANADA | 100 | 1500 |
amp | AUSTRALIA | 200 | 1500 |
amp | NETHERLANDS | 300 | 1500 |
Maybe I need somehow to add the “country” to the formula I don’t know the syntax
Can you help me?
Here my set analysis
=sum({<Calendar_Date={">=$(=MonthStart(Max(Calendar_Date), -11))<=$(=MonthEnd(Max(Calendar_Date)))"},Calendar_YearMonth=,Calendar_Year=,Calendar_Month=,Calendar_MonthName=,Calendar_MonthNameLong=,[Calendar Month_Year]=,Calendar_MonthYear=,[Calendar Month/Year]=,From_MonthYear=,To_MonthYear= ,Calendar_Type=>} TOTAL <Corporate> Total_PrintingImp )
thank you
It's not about set analysis, it's about your use of the TOTAL qualifier.
If you only have two dimensions, remove the qualifier.
Or add country to the field list:
TOTAL<Corporate, Country>
thank you
you rigth i need to remove the TOTAL qualifier and it's work
by addind country to the field list it is not working