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,

Please I have a  chart that shows stacked bars for Sales and Target into one. But I will like to have the value of the sales in the section of the bar that represents Sales and the the value of the total target in the part of the bar that represents Target. I tried using "Value on data points on both expressions" but its not given me the expected results.

Please help me out.

Thanks.

[Digvijay_Singh]

Can you pl share a sample and expected output.

[#4]

Sales Rep       Sales          Target

Simon             € 25,000     € 55,000

Martin              € 35,000     € 45,000

Paul                 € 50,000     € 100,000

Rudy               € 30,000       € 75,000

Frank               € 20,000       € 45,000

Eli                    € 18,000       € 41,000

John                 € 15,000        € 35,000

Heidy               € 14,000        € 40,000

Lisa                   € 9,000          € 30,000

Delian               € 10,000         € 45,000

So I will like to have the amount of Sales for each Sales Rep in the blue part and Amount of Target in the Red Part

[Anil_Babu_Samineni]

Like This

If you want to show something like Euro Money

Then goto Number Tab --> Select your two expressions --> Choose Money Radio Button then Use this €#,##0;(€#,##0)

[Digvijay_Singh]

Check this out -

Were you missing this option in presen tab?

[#7]

Thanks Digvijay

[#8]

Hi Digvijay,

Please I will like to use the value in the column row of one table in another table. Is that possible?

For example

Sales Rep       Sales        Target

Simon             € 50,000      €150,000

John               € 45,000      € 85,000

Henry             € 15,000      € 60,000

But I have another table that is not related to these one and I just want to reference the sales for Simon in the other table. Please can you help me to achieve these?

Thanks

[Digvijay_Singh]

You can create map of Sales rep and sales and later can use it at the place where Sales rep is available but not sales, like below -

Map_SalesRep_Sales:

Sales Rep

Sales

Resident yourtable;            //( this table must have both sales rep and sales)

and then in another table you can use populate sales amount as -

Load

.....

.....

[Sales Rep]

Applymap('Map_SalesRep_Sales',[Sales Rep]) as Sales

From

........

Thanks,

Digvijay

[Digvijay_Singh]

Forgot mapping load statement -

Map_SalesRep_Sales:

Mapping load

Sales Rep

Sales

Resident yourtable;            //( this table must have both sales rep and sales)

[#11]

Thank you Digvijay