Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
My scenario is that, i am applying 'time frame' filter to the straight table, so the values for time frame is like '3months vs 3months' or '6months vs 6months'. so i need to apply this to the table, i was trying like assigning monthid=3, if we select 3months vs 3months and monthid=6, if we select 6months vs 6months.
And the data in the table is 'Volume'.
so the if condition look like
=Sum(if(prod='Humira',Vol))
but i want to assign even filter value with this if condition like
=Sum(if(prod='Humira',Vol,if(Time_Monthly='3Months Vs 3Months')))
but this is not working
so how i can get two values in if condition. Vol and monthid=3 or 6 based on filter value?
Not sure if I completely understand, but you could use logical operators like and / or to combine conditions, maybe like
=Sum(if(prod='Humira' and Time_Monthly='3Months Vs 3Months',Vol))
thanks for the information,
i will try it out...