Count negative customer and display the last 12 month

[keitel2015]

Hi,

I am looking for the correct formula for my problem. I want to create a bar chart which displays the number of negative customer (based on profit). The bar chart should displays the last 12 months. My fields are: [Fiscal Date], [Customer ID] and Profit. I have a solution if I added the [Customer ID] dimension too but I need a solution without [Customer ID] dimension. My current formula is this: Count({1} DISTINCT [Customer ID]).

[keitel2015]

Thank you very much ! That is exactly what I needed.

What is the best way to display only the last 12 month and not the whole fiscal dates? Calculated dimension or set analysis in the expression?

[sunny_talwar]

If there are multiple expressions, I will go with a calculated dimension, if there is only one expression, then set analysis would make more sense.

HTH

Best,

Sunny