Hi all, I am creating a calculate field for the cont. YoY of the variable IMP grouped by Categories.
(sum({YoY Delta IMP})*{LY CTR}/{LY Clicks}*100) - then added to Category table (rows=categories)
When I add this variable to the visual (table), the result is breakdown by the defined Group by which is Category. However, for the purpose of the formula, LY Clicks should remain at highlevel to calculate the IMP contribution by Category (in other words, I don’t want the visual to impact/breakdown that specific part of the calculated field).
Is there any way to fix this value?
Thanks!