Hi all,
I am looking for a way to show total sales performance for various items relative to individual users performance for their own sales performance. Please see attached image for a better illustration of what I am trying to accomplish.
In this example, I want to pass the logged in user name into a case statement.
Something like:
SUM(CASE WHEN Supplier
= Logged In User
THEN UNIT SALES
END) in conjunction with FIXED BY formulas to get % of Totals.
Does anyone know of a way to pass logged in user into a beast mode? If not in beast mode, is there an alternative way that gets me to the same result?