Alternate States ?

[#1]

Hi All,

I have Year & Month Filters, Product Group & Region Filters are there in Dashboard...

I need to Keep a Limitation for For one Chart Where Year & Month Filter Should not WOrk...

Can any help me on this Urgent..

Regards,

Heather

[mdmukramali]

Dear,

In set analysis use like

if Year and Month are in same State of Dashboard then use the expression like below.

=Sum( {<Year=,Month=>}Sales)

if Year and Month are in different state then no need to include them in the expression it will not effect on year and Month selections.

if you need something else you can share sample file so that we can help u.

Thanks,

Mukram

[ashfaq_haseeb]

Hi,

use this expression where you want to omit filters

=Sum( {<Year=,Month=>}Sales)

Regards

ASHFAQ

[#4]

HI Ali,

It was a big Set Analysis Expression its not possible...

Can you tell Some option na..

Regards,

Heather

[mdmukramali]

Dear,

In that set analysis include this

Year=,Month

Thanks.

[#6]

HI Ali,

its not possible to include year & Month, That O/P is coming on Various Dates & Years ...

Please try to understand & give me an Exclude option for Year & Month filter for that Particular Chart....

please help me on this

[ashfaq_haseeb]

Hi post your expression here.

[#8]

Based Year & Month Filter it Should not change...

Sales:

=Num((((Sum(If([Invoice Year] = Year('$(vMaxDt)'),[Invoice Turn Over]))+

(sum(IF(YEAR(DN_TRAN_Dt) = Year('$(vMaxDt)') AND [DN Dr/Cr] = 'C' AND [DN CODE] LIKE '301*',[DN_Finance INR]))-

sum(IF(YEAR(DN_TRAN_Dt) = Year('$(vMaxDt)') AND [DN Dr/Cr] = 'D' AND [DN CODE] LIKE '301*',[DN_Finance INR])))+

sum(IF(YEAR(JV_TRAN_Dt) = Year('$(vMaxDt)') AND [JV Dr/Cr] = 'C' AND [JV CODE] LIKE '301*',[JV_Finance INR]))+

sum(IF(YEAR(CJV_TRAN_Dt) = Year('$(vMaxDt)') AND [CJV Dr/Cr] = 'C' AND [CJV CODE] LIKE '301*',[CJV_Finance INR]))+

sum(IF(YEAR(RJV_TRAN_Dt) = Year('$(vMaxDt)') AND [RJV Dr/Cr] = 'C' AND [RJV CODE] LIKE '301*',[RJV_Finance INR])))-

((Sum(If(Year(CN_TRAN_Dt) = Year('$(vMaxDt)') AND [CN Dr/Cr] = 'D' AND [CN CODE] LIKE '301*', [CN_Finance INR])) -

Sum(If(Year(CN_TRAN_Dt) = Year('$(vMaxDt)') AND [CN Dr/Cr] = 'C' AND [CN CODE] LIKE '301*', [CN_Finance INR])))+

sum(IF(YEAR(JV_TRAN_Dt) = Year('$(vMaxDt)') AND [JV Dr/Cr] = 'D' AND [JV CODE] LIKE '301*',[JV_Finance INR]))+

sum(IF(YEAR(CJV_TRAN_Dt) = Year('$(vMaxDt)') AND [CJV Dr/Cr] = 'D' AND [CJV CODE] LIKE '301*',[CJV_Finance INR]))+

sum(IF(YEAR(RJV_TRAN_Dt) = Year('$(vMaxDt)') AND [RJV Dr/Cr] = 'D' AND [RJV CODE] LIKE '301*',[RJV_Finance INR]))))),'#,##0')

Budget:

num(sum(if([Target Month] <= month('$(vMaxDt)') and [Target Year] = Year('$(vMaxDt)'), [Sales Target])),'#,##0')