Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
My requirement is that I have a list box.Whenever I select any values in list box the values in the chart should not get affected .Can anyone suggest me how to implement the change in front end in chart so that selections do not affect.
Thanks
Sriram
Can anyone tell me how to resolve the above error.It is bit urgent.
hi
in chart write distinct before your field.
I tried with distinct keyword ,but it is not workigng properly.Selection made in the list box should not change the pivot table values.
I tried with distinct keyword ,but it is not workigng properly.Selection made in the list box should not change the pivot table values.
Can you please post a sample of what you are trying to achieve?
I am sure Set Analysis will do the trick, but i need to be certain how you want to do it?
My expression in pivot table is
=NUM(Sum(Distinct([Supply Plan])))
& if(Plan_For_Month >=monthstart(today()),Sum(([Supply Plan 1])))
and the dimension used in pivot table is
=Date(Plan_Made_Date,'MMM YYYY') and =Date(Plan_For_Month,'MMM YYYY')
I have field called lag which has values 0,1,2,3 which is calculated on the back end. Requirement is whenever I select any values for lag the values in pivot table should not change.
Thanks
Hi
Try this
=
NUM(Sum(Distinct{$<FeildName>}([Supply Plan])))
& if(Plan_For_Month >=monthstart(today()),Sum(({$<Feildname>}[Supply Plan 1])))
Regards
Kaushal Mehta
when I tried the above expression I am getting error in expression
=NUM(Sum(Distinct{$lag}([Supply Plan])))
& if(Plan_For_Month >=monthstart(today()),Sum(({$lag}[Supply Plan 1])
can you please advise how to rewrite the above expression without error
Use {1} in ur expression
i gives all the values if u select the values in the list box
try this sample
sum({1}amount) likethis
=NUM(Sum({1}Distinct([Supply Plan])))
& if(Plan_For_Month >=monthstart(today()),Sum(({1}[Supply Plan 1])))
try this