Value in Pivot table

[#1]

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

[#2]

Not working,

Find the sample qvf.

[Anonymous]

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?

[#4 · Accepted solution]

I found the answer

IF(match([$25 New Members] , 'Invitation Email'),Only({$<campaign_name_id={"19"},email_type_id = {'44'}>}sent))

[Anonymous]

Good