Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have this problem, when I apply a formula to the following years MonthName(Max(Periodo), it returns the last month of the year with data, which is correct, but doing so in this way '$(=MonthName(Max(Periodo)))', brings me the total value, could someone help me, I need the Value in quotation marks for a set analysis Thank you
Hi Jonathan,
The difference between the $() expressions and the ones without $() is that the first is evaluated globally, for the entire data set. The latter is evaluated for each row, thus is taking into account the dimensions used in the table.
Have a look at the attached file. Is not the best solution, but I hope it will provide you with some useful hints.
Regards,
David
Hi Jonathan,
'$(=MonthName(Max(Periodo)))' is evaluated once per chart.
Regards,
Antonio
try without the equal sign
$(MonthName(Max(Periodo)))
Hi Jonathan,
The difference between the $() expressions and the ones without $() is that the first is evaluated globally, for the entire data set. The latter is evaluated for each row, thus is taking into account the dimensions used in the table.
Have a look at the attached file. Is not the best solution, but I hope it will provide you with some useful hints.
Regards,
David
thanks for your answer Antonio
I already tried, thanks for your answer Vinneeth
Thank you very much for your answer, it is very useful to solve the problem that I have, thanks David