Bar display one-on-one

[jagannalla]

Hello,

I've a table with fields Date and value. I want to display the sum of the value based on dimension date(i.e. first half one part, second half another part).

For eg:

Jan-Aug->4000

Sept-Dec->2000

Jan-Dec ->6000

The chart should look like this:

- The blue color shows data of value from jan to aug, red from sept to dec. Green shows entire data for 2012.

How can i achive this.

[Jason_Michaelides]

Please post your app.

[jagannalla]

Please check enclosed app.

[Jason_Michaelides]

How's this?

[Jason_Michaelides · Accepted solution]

Slight adjustment to the dimension names...

[jagannalla]

I find the solution in best way i think so. Please check the file once.

[rajni_batra]

i have never used the function valuelist & didnt even find Qv help. can u explain y we use this

[Jason_Michaelides]

Your script is only using Month() therefore the same months in different years will be grouped together:

     If(Year(DateField)=Year(Today()),'Actual/Projected') as "Actual/Projected",

     If(Month(DateField)*1<$(vCurrentMonth),'Actual','Projected') as FleetCapacity, 

Maybe try:

     LET vCurrentMonth= Today();

     If(Year(DateField)=Year(Today()),'Actual/Projected') as "Actual/Projected",

     If(DateField<$(vCurrentMonth),'Actual','Projected') as FleetCapacity, 

[Jason_Michaelides]

It's in the help - look for "Synthetic Dimensions"