Remove columns with 0 as value in Dimension/measures not supress values etc

[MK9885]

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.

stalwar1‌

[Anil_Babu_Samineni]

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?

[MK9885]

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.