Matrix - hiding rows/columns

polonious

Hi Guys,

Hope you can help! I've got a Matrix form with customers listed on the left, and sales (by Product Group) across the right side of the Matrix form. What I need to be able to do is, a) hide customers that have 0 sales, and b) hide Product Groups that have also had no sales. Can anyone think of a good way to do this, particularly (b).

Thanks in advance.

Polo

kine

It is problem, because only visible cells are calculated and if you want to do this, you will need to calculate all cells. But you can use some temporary table where you will prepopulate the values and make the selection. It means when opening the form, there will be some process filling this temp table (with appropriate progress dialog) and after that, the matrix box will open with only needed data. But do not forget, that there can be theoretically unlimited records in both directions and it is why this requirements is not easy to do...

polonious

Thanks Kine, I had thought of a temporary table, but wasn't sure if there was an easier way. Will give it a go.

Thanks.