Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement to group a measure into 2
I got single dimension as YearMonth
2 measures, one is for Amount A and another is for Amount B
From Jan to June there are values for Amount A
From July to Dec, values for Amount B
Since I'm using 1 dimension which will span from Jan to Dec...
2 columns are made Jan will have value for A but 0 for B
I want to eliminate the column where ever it is 0.
Can be possible, But how you analyze that? Let's assume
Load * Inline [
YearMonth, Amount A, Amount B
Jan, 60,
Feb, 50,
Mar, 40,
Apr, 30,
May, 20,
Jun, 10,
Jul, , 60
Aug, , 50
Sep, , 40
Oct, , 30
Nov, , 20
Dec, , 10
];
This is the case, What you want in chart?
Sorry I did not understand this...
I'm using Single measure for now and Single Dimension
Jan to July has my current Amount
Aug to Dec has my Forecast Amount
I get correct values for this
when I use 2nd measure by using a filter in set analysis it gives me 0 for Forecast Amount from Jan to Jul
and 0 for Current amount from Aug to Dec
Below is my expression....
Sum (Amount) --- Current Single Expression
Trying to add new expression
Sum(CurrentAmount)
Sum(ForecastAmount)
I used Set analysis filter like CurrentAmount-={0} did not work
Tried Aggr for dimension did not work...
Any help would be appreciated.
Thanks.