Trying to create multiple total to 1st half and 2nd half of the year

[#1]

Good day ma'am/sir,

please help, i dont know how to do a multiple total for the 1st and 2nd half of the year

i mean like this,

i dont have any idea how to do it,

thanks in advance,

your help will be very much appreciated.

thanks in advance.

have a nice day everyone!:)

[er_mohit]

hey try this

in your chart if you want to get total 1h  upto july

then

in expression

try this

column(1)+column(2)+column(3)+column(4)+column(5)+column(6) and for total 2 h

try this

column(8)+column(9)+column(10)+column(11)+column(12)+column(13)

[#3]

Thank you  er.mohit for the reply,

sorry i forgot to mention i have the dimension month w/c have months jan-dec and that total 1H and 2H i just created it in excel,

what i want to do here is i want to get the total of the 1st half of the year from jan-jul and also total for 2nd half and whole year.

i can do this but,

but i want to do it like this

so is it possible that i can divide dimension month field into 2 parts namely 1st half and 2nd half so i can create a multiple partial sums for both of them?

[kaushiknsolanki · Accepted solution]

Hi,

     There is no way to do this by keeping the month as dimension.

     The work around is you create an expression for each month. something like

     Sum({<Month = {"Jan"}>}Amount)

     ............

     And then use the method told by Mohit to get the Half year Total.

Regards,

Kaushik Solanki    

[#5]

Thank you sir,

sorry i thought it was possible,

thank you for your help sir,

also to you er.mohit thank you for the help:)

i appriciated it!:)