Display message per selection

[#1]

Hey guys,

From the table below the goal is to have sales every month for all the shops shown on the right. But if for example when selecting a shop in this case Hilltop 58 and there are months without any sales as in the case  of Mar, Jun, Oct and Dec, then a message should be displayed saying " There were no sales in the months of Mar, Jun, Oct and Dec for Hilltop 58".

Please any help on how to achieve these will be great.

Month              Sales

Jan                  € 2,500,25

Feb                  € 1,252,00

Mar

Apr                    € 500.25

May                  € 3,500,95

Jun

Jul                    € 4,652,85

Aug                    € 10,458,87                                          SHOPS

Sep                    € 15,896,45                                        Hilltop 58

Oct                                                                              T- Square 45

Nov                    € 25,875,65                                        Spring bell 38

Dec                                                                              Down beach 10

                                                                                    Coastal city 5

Thanks in advance.

[#2]

Hi Digvijay,

I adjusted the expression based on the sample it worked thanks but, the months don't appear in an orderly manner like "Jan, Feb Apr,May, Aug" instead "Apr,Aug,Feb,Jan". In addition, when no selection is made, the show condition does not apply but rather display the entire solution in the expression and only disappear again if a selection is made that does not meet the condition.

[Anil_Babu_Samineni]

1) Go to Sort tab and then arrange as per your Rek?

- Anil

[Digvijay_Singh]

Try by giving third parameter(Start_Month) in the concat exp, after ',', I think the earlier text box we gave third parameter to sort the list.

The other no selection issue, what do you expect when no shop is selected? we may add condition to only show text box when selection exists in the shop list box. Can you share your expression, I may add this condition once you confirm.

[#5]

I added the third parameter Start_Month and now the months are sorted properly. Thanks. But for the selection issue, I don't expected to see the text box when no shop is  selected.

Here is the expression I used for the show condition:

Aggr(Count(DISTINCT{<Abonnement = {'DM-CFV','DM-CFB','DM-E&F','CFB','DM-E&A'},InvoiceTypeID = {2}>}PaidWithTax),Start_Month,Product,shop)>1

[Digvijay_Singh]

Add this in the start in show condition expression-

GetSelectedCount(Shop)>=1 and

[#7]

There are some shops that don't meet the condition and when such a shop is selected, i get the empty text "Have PaidWithTax greater than one".

[Digvijay_Singh]

I don't see this happening in my sample, can you share your final expression?

[#9]

I just did

GetSelectedCount(Shop)>=1 as you suggested

[Digvijay_Singh]

Do u see any difference in this shop and other which are working, the data may reveal what we have missed in our expression.

[Digvijay_Singh]

I think you forgot to add 'and' at the end of this condition