Create Buttons for last/next Element?

wzsycdh

Hello,

I have Dimension, where customers are assigned to agents. One agent has one or more customers assigned to him/her and the customer can only be assigned to one agent. As in the file attached I want to create an excelsheet (will be published to tm1web!) where the agent should be able to click on a "Next-"button and the title element "Unit" (his customers) should change to the next customer that is assigned to him. When clicking on "last" the last customer should be viewable. Is that possible (without macros)?

Thanks a lot for any hint,

Toto

sunnypure

Why try and make TM1 do something it doesn't natively do when there is perfectly good functionality already built in? Instead of the Next Unit/Last Unit button idea (sounds to me like you are trying to mimic Access) use a SUBNM formula. In the cell where you have the ABC Merchandising make it a SUBNM formula into the customer dimension. If you secure this dimension and give the salespeople access to only their customers then when they click on the cell they will be presented with a Subset Editor selection box that will list only their customers. Instead of paging through the list, only seeing one choice at a time, they will be able to select any customer, first, last, or one in the middle.