Hello,
I am using filter and organize both at the same time. like i have a table and columns are :-
ID – TITLE – PARTY – PAYMENT STATUS
so i am organizing it by PAYMENT Status and then TITLE . .
then i added a filter for PAYMENT STATUS to show only Pending, Invoice Sent, Received etc. but not to show which row has PAID status.
but when it works perfectly but only problem is it is showing Headers for Organize Key (like here PAID and TITLES) which is already hide by filters
so how can i set the table which value is hidden or filtered should not show in Organize table.
Here when Filter On (to hide only Paid Status)
https://ibb.co/z2swgTY
I hope this images will help you…. i want to explain you this once again….. i want to know how to hide that rows(headers for Organize table in black) appearing which has Paid status when data is filtered ..
Building a App based in Numbers
Device: Mac Running Big Sur
App: Numbers
—–
Kailash Purohit
So you are using Categories to organize your table, and you don't want to see the columns that you are using as Categories?
Just hide those columns then. You can click on the column top and choose Hide to hide the columns you don't want to see.
Thank you very much for your response ... actually i had problem with rows (not column) .. the rows was appearing in black under PAID... actually that PAID value is filtered and ask Numbers to hide when it is PAID... but thank you very much for your guidance for this and all the past one.... i am still improving this and will have lot of questions..definitely will ask you :)
and i found the solution for this (not really) .. just collapse the PAID rows :D
Kailash: Those special rows are part of the Category feature in Numbers. If you'd rather not see them, then don't use the Category feature. Instead, just sort your table as you like. So in this case you'd sort by Status and Title, instead of setting those as Categories. Or, you could put one as a Category and the other as the Sort By setting.