Numbers - Pivot Table with data from different sheet

Question

Nível 1

4 pontos

Numbers - Pivot Table with data from different sheet

Hi!

I'm trying to build a Pivot Table on a specific sheet which already has a lot of data but I want to use data from a different sheet.

I've tried creating the pivot table on a new sheet or on the same sheet but I can't copy the table for the desired sheet. I also tried to create a Pivot Table on the desired sheet and change the origin data, but I can't select data from a different sheet.

Is there any way for me to do this?

Thanks

MacBook Air 13″, macOS 14.2

Publicado em 13/03/2024 13:07

Responder

Answer 1

16/03/2024 06:11 em resposta a mafalda86

Olá mafalda,

Novo no seletor de modelos:

Para mover uma tabela dinâmica para outra planilha, clique em qualquer lugar da tabela para ativá-la. Clique no ícone no canto superior esquerdo conforme mostrado para selecionar a tabela inteira.