Automatic field selection

[#1]

Hi all,

I have the following problem.

I have a data report , when I select there a specific field value, there is another field which is selected  automatically too.

I don't want this additional field to be selected because , when I add values to my first selection the unwilled automatic selection limits the results.

What do I have to do in order to stop the unwilled automatic selection?

For example in the file attached, I chose Seat RA, I did not choose PPublisherName, so why is it chosen anyway?

Thanks ,

Inna

[#2]

Hi,

In tab Heavy analysis you have expressions - Impressions,Clicks etc.,

So in Sum expressions I put for example, Sum({$<PPublisherName=>} BuyerImpressions) instead of sum(BuyerImpressions) and so on.

Would appreciate very much if you could help me.

Thanks,

Inna.

[Caique_Zaniolo · Accepted solution]

Inna, you are using a Calculated Dimension in your Cyclic Group based on the Publisher Name, that is the reason we get some selections on the PPublisherName field.

[#4]

Hi, I understand.

Can I leave this calculation and avoid the situation, or I need another solution for the calculation?

Thanks,

[Caique_Zaniolo]

You could create the field on the script using the if statement you have and then use the field you created in the cyclic group.

[#6]

Hi,

I followed your advise and everything works is it should!!!

Thanks a lot,

Inna.

[#7]

Hi giampiero,

I followed Caique answer and everything is excellent now.

Thanks,

[#8]

Hi Inna,

Caique found a very good solution.

Happy for you

Regards

Giampiero