Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a chart & a pivot table in which I wanted to show the data from the January month till the month selected in the filter for the respective year.
could you please help me to fix the formula.
Make a small modification in the variable declaration like highlighted here:
FCS_Chart1_Actual
sum({<ObjectID={$1,$2,$3},Dept={$4},[Month] ={"<=$(=Month)"}>}Actual)
Similar change for FCS_Chart1_Target
Hi,
Thanks for your reply. Unfortunately is not giving the expected answer. It is giving same output as per my formula.
PFA
Hi Tresesco,
Thanks for your reply. after checking your file it seems that it is working. could you please let me know what you have changed in the graph to get the expected result.
Many Thanks,
Made changes in the variable definition (not in chart ) as already mentioned above.
Sorry to say, but I can't find any change in the formula of the chart & function written in the script in your file
Hi Tresesco,
Thanks for your kind help. could you please let me know what should I write in the script function of Month selection as every time I reload the dashboard the condition goes away.
for ex : sum({<ObjectID={$1,$2,$3},Dept={$4},[Month] ={"<="}>}Actual)
every time I reload the document the month condition goes away.
Thanks