Hi all,
i am trying to get into numbers after using Excel for a long time. Currently I want to rebuild the following scenario within numbers:
I have one sheet which contains the raw data which are transactions with some categories and a value. Than I have several sheets with different pivotable to get different views on the data. The raw data sheet gets round about 10 new entries a month which are automatically used by my pivotable. Is this possible in numbers as well?
I can only find how tos for smart categories which tell me how to transform the raw data directly. But I want to keep it as I want to use it more than one time.
i am trying to get into numbers after using Excel for a long time. Currently I want to rebuild the following scenario within numbers:
I have one sheet which contains the raw data which are transactions with some categories and a value. Than I have several sheets with different pivotable to get different views on the data. The raw data sheet gets round about 10 new entries a month which are automatically used by my pivotable. Is this possible in numbers as well?
I can only find how tos for smart categories which tell me how to transform the raw data directly. But I want to keep it as I want to use it more than one time.