Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello , i have a question please if you can help me .
I have table :
Cat. Produ. V1. V2. Target
Cat1. P1 30. 50. >
Cat1. P1 40. 30. <
Cat1. P2 60. 50. =
Cat2. P12 60. 50. >
Cat2. P12 60. 50. >
I want :
V1 =if produ like p1
,If (v1>v2 and target= '>' , 1 , 0)+ ....v1>v2 and target= '>' , 1 , 0)+
I for Produ variable v1 telle me
For produ how much i have true
I wante do it for cat like drile down (cat_produ)
But i cant
Van you help me
Hi!
I would suggest go with script approach, so you can create your field on back end:
If you are lazy and prefer inefficient solution, just create a dimension like this: