Calculating Total of YTD Calculation Based

[#1]

Hi There,

             I am quite new to  both Qlikview as well as the discussion Forum. I have a problem with Calculating Total for a Calculated field which is YTD Calculation

The Formula of YTD Calculation, which works on single selection , is attached below.It Works when I select only one OrgUnitName but When I choose Multiple orginsational Unit it Shows 0.

What I am trying to achive is Total of YTD at theTotal Level. Pictures Attached for Examples

********************************************

sum({$<GLYear = {$(=only(GLYear))}, GLMonthNo = {"<=$(=Max(GLMonthNo))"},OrgUnitName={"$(=(OrgUnitName))"}>} (GLTotalAccountCredits+GLTotalAccountDebits))

*************************************

Please help.

[#2]

Can you upload your sample application. will do the needful for you.

[#3 · Accepted solution]

Yahoo I have Figured Out the Calculation, Very Happy ....Yahoooooo!!!!!!!!!!!!!!

Here is it.

IF(ParaquadTotalName='Total',(SUM({<ParaquadTotalName ={'Total'} >} (Aggr(sum({$<GLYear = {$(=only(GLYear))}, GLMonthNo = {"<=$(=Max(GLMonthNo))"}>} (GLTotalAccountCredits+GLTotalAccountDebits)),OrgUnitName,TreeName)))),(SUM({<ParaquadTotalName = >} (Aggr(sum({$<GLYear = {$(=only(GLYear))}, GLMonthNo = {"<=$(=Max(GLMonthNo))"}>} (GLTotalAccountCredits+GLTotalAccountDebits)),OrgUnitName,TreeName)))))