Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a fact table which contains Id1, Id2, Type, ItemCount. As per business, there should be a unique combination of Id1 and Id2. But in fact table more than one Id2 value is available for a particular Id1 value.
So to find out the unique combination, we have another table which contains Id1 and UniqueId2.
I want to show the sum of ItemCount for each Id1 which have the Type = 'A'....like count(if(Id2=UniqueId2 and Type='A',ItemCount))
But this value should not be changed by the selections in "Type" filter...
How to achieve this?
Try:
sum({<Type={'A'}>} if(Id2=OriginalId,Item_Count))
Hi,
Try this.
sum({1<Id2 = p(OriginalId), Type = {"A"}>}Item_Count)
Regards,
Kaushik Solanki