HI guys
i am working on a report where i have created a calculation to show the latest comments as shown below,
{FIXED [Product],[Dep]:MAX(
IF [Month]= {FIXED [Product],[Dep]:MAX([Month])}
THEN [Comment]
END
)}
this seems to be working fine.
I have a page shelf filter selecting the dep which i want to show on the page, the issue i am having is for product A , i have one blank row because , the calculation filed is still bringing the comment for this as this isnt filtered out, it is only selected in the page shelf filter.
is there anyway i can maybe apply the page filter in the calculation field so the results are only shown for the dep selected in the page shelf filter?
i have attached the example workbook
below is what i want to show when kpi 1 is selected in the page shelf filter
not using pages
You could improve the UI using either a parameter action or a set action with a visual value picker so the user could role through departments without using a dropdown filter
see the attached example
it is not you problem but illustrates the use of value pickers on a dashboard
also see See it your way: Put life in your Viz with Set and Parameter actions and Viz in Tooltip for a step by step on how it is done
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
