Grouped Bar Chart - Data Issue

[Jrampone]

Hi,

I currently have my data laid out in the attached Excel format. 

In the measure I have Financials and in my dimension I have the following:

=sum(if([Project name]='Abacus',[This Month]))

=sum(if([Project name]='Abacus',[Last Month]))

=sum(if([Project name]='Domino SAP rollout',[Last Month]))

=sum(if([Project name]='Domino SAP rollout',[This Month]))

=sum(if([Project name]='Market Entry Strategy',[Last Month]))

=sum(if([Project name]='Market Entry Strategy',[This Month]))

When I apply a filter of [Project Name], all the other projects appear as 0 (see attached).

How do I remove the zeros and the extra spacing from showing when I have the project filter on, so that it only shows the data (VAR, ETC, Budget, etc. in the Financials field) for the project I selected for this month and last month?

[vikasmahajan]

Hi ,

To avoid Zeros from chart  un-tick include zero value 

[Jrampone]

Hi,

I have deselected the include zero values box, but the zeros are still showing.

Any other suggestions?

Cheers,

Josh 

[vikasmahajan]

In Dimension un-tick include null  values 

[Jrampone]

Hi There,

I deselected the the include null values in the Data tab. The Zero values still seem to be showing 

Cheers,

Josh

[vikasmahajan]

can you attach a sample qvf ?

Vikas

[Jrampone]

Hi Vikas,

Attached is a sample!

Cheers,

Josh