Using a Table: Set Analysis is effected another column

[Anonymous]

Hi All,

I created a report that shows ONLY customer purchases, if the customer didn't purchase anything in the last 3 months

(I call it Inactive customer report...)

I use a set analysis in a straight table like this:

Max( {$ <[Month Diff]={"<-$(Inactive  Duration)"}>} Date)

** [Inactive Duration] is a variable that the user can change by himself

the expected result is as follows:

the problem is when i add an additional expression column, that says which product the customer purchased, like this:

CONCAT( distinct ServiceName,',')

**I use concat since the customer can purchase multiple items on the same date

this is the result i get:

meaning the last posting date shows as "-" since it doesnt apply the set analysis

my question is - why is it showing?

A few Details:

these are the tables that i am trying to set analysis: on the 3nd column on the Fact table, and the concat function is on the 2nd column

[sunny_talwar · Accepted solution]

Try this for Upgrade Description expression and see if this solves your problem:

If([Last Posting Date] > 0, yourCurrentExpression) (I can't read the name of your second last field from the second image, but that's what I think it is, use the exact name here)

This will force to remove all the Concatentated descriptions where there is no Last Posting Date in your chart.

HTH

Best,

S