Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am creating a pivot table, where i am using custom dimensions like below:
NewDims:
LOAD * INLINE [
25 New Members,10 New Members
Invitation Email, Invitation Email
Reminder1 (signups), Reminder1 (signups)
Reminder1 (non signups),Reminder1 (non signups)
Reminder1 ,Reminder1
Reminder2 (signups),Reminder2 (signups)
Reminder2 (non signups),Reminder2 (non signups)
Reminder2, Reminder2
Final Reminder (signups), Final Reminder (signups)
Final Reminder (non signups), Final Reminder (non signups)
Final Reminder,Final Reminder
];
The above dimensions comes in 1st column, in 2nd column i need to put the count.
IF(match([25 New Members] , 'Invitation Email'),sent))
Now, I need to filter the sent count for particular type. how can i use the set analysis without using the aggregation.
For example: sum({$<email_type_id = {44}, campaign_name_id = {"$(=max(campaign_name_id)-11)"}>}sent)
Will give the sum of sent count for particular email_type_id and campaign_name_id,
I have only one row for email_type_id =44 and each campaign_name_id so i don't want to sum just i need to get the value of sent in that row.
please help on this.
Thanks,
Pramod
Not working,
Find the sample qvf.
okay, does these combination exist?
how these fields are linked?
[$25 New Members]
email_type_id
campaign_name_id
sent
I doubt, the combination you mentioned does not have any sent value..
Does these fields associate with each other?
I found the answer
IF(match([$25 New Members] , 'Invitation Email'),Only({$<campaign_name_id={"19"},email_type_id = {'44'}>}sent))
Good