Hide names in a top 10 table

[#1]

Hi peeps,  I've made a top 10 table and I want to send it to a customer however I dont want them to see the other 9 customers names...I want them to show XXXX instead of the name eg

Customer     Sold

HMV          100

Virgin          97

OurPrice     85

The Virgin customer will get....

Customer     Sold

XXXX          100

Virgin           97

XXXX          85

You can select which 10 customers you want in the table and which one you want to single out.  Is there a way of doing this?

Thanks in anticipation

[jafari_ervin]

Hi Jonathan,

I implemented your request with Section Access.

Please see the attachment and let me know your Idea.

User: User1,User2,User3

Pass: 123

Best regard,

[sasiparupudi1]

Hi

Just Curious..

How can you stop the user from using another listbox or a tablebox or a chart to display the customers in the table?

Sasi

[#4]

Hi Jafari

That's a really interesting way of doing it, and i'll use that for another task I have to complete.  However I dont need to be concerned about exposing data to the customer as this dashboard will be an internal dashboard.  Is there a way of selecting the customer in a listbox and then referring to that within the expression.  eg  could I have 2 listboxes, in one I select "Virgin" in the other I select "VIRGIN, HMV and OURPrice, then I'd like the table to say

Customer     Sold

XXXX          100

Virgin           97

XXXX          85

Can you think of a way of doing this, maybe using the "if customer=vCustomer then customer,XXXX."  how do I associate the 1st listbox with the vCustomer variable?

[ramoncova06]

how are you sending them this data ?

you could probably get this by using alternate state

[#6]

its being displayed on an internal dashboard.

How can I do this with alternative states?