Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have table like below. And requirement is if Dim=C then I need sum(Val1) and I have writtern expression like below but problem is if I select any Dim value then it is disappearing but as per my requirement it shouldn't be disappear. so If I select A then C value is 100 and for B 200 and for C 300.
LOAD * INLINE [
Dim, Val, Val1
A, 10, 100
B, 20, 200
C
];
if(Dim = 'C',
$(=sum(Val1)),
sum(Val)
)
-Priya
it is already tried and it is not working
that should work. can you share a sample qvw?
PLease find application with same set of data.
Hi Thanks for the effort, if I select A then C is disappearing, it should not happen
Hi Priya,
Please find attached solution.
Regards,
Pankaj
Please find new app for solution.