Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
use this expression where you want to omit filters
=Sum( {<Year=,Month=>}Sales)
Regards
ASHFAQ
HI Ali,
It was a big Set Analysis Expression its not possible...
Can you tell Some option na..
Regards,
Heather
Dear,
In that set analysis include this
Year=,Month
Thanks.
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
Hi post your expression here.
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')