Skip to main content
Solved

Why Empty Row is added automatically in This Table and how to remove it.

  • May 13, 2023
  • 5 replies
  • 128 views

abhilashsawla
Master Author
Forum|alt.badge.img+7

Hi 

I Have created a table, but an Empty Row is getting added there with data and not getting any Error while applying formula.

 Please help to solve this problem and Screen Shot is attached here for your reference.

 

Best answer by Benoit

Hi, Thank you for the screenshot.

I would be interested in seeing what is inside the A2 Type > F1 P&L pivot.

Is it possible that you have an (Empty) item in F1 P&L ?

 

If not, I suggest you create a Support ticket so we can give it a deeper look.

Please let me know.

Thanks,
Benoit

5 replies

Benoit
Community Manager
Forum|alt.badge.img+15
  • Community Manager
  • May 15, 2023

Hi Abilash,

 

This one is interesting. Could you please screenshot your pivot configuration as show below?

Thanks.

 


abhilashsawla
Master Author
Forum|alt.badge.img+7
  • Author
  • Master Author
  • May 15, 2023

 


Benoit
Community Manager
Forum|alt.badge.img+15
  • Community Manager
  • Answer
  • May 16, 2023

Hi, Thank you for the screenshot.

I would be interested in seeing what is inside the A2 Type > F1 P&L pivot.

Is it possible that you have an (Empty) item in F1 P&L ?

 

If not, I suggest you create a Support ticket so we can give it a deeper look.

Please let me know.

Thanks,
Benoit


abhilashsawla
Master Author
Forum|alt.badge.img+7
  • Author
  • Master Author
  • May 16, 2023

Hi @Benoit 

I have empty mapping in A2 Type > F1 P&L so, because of that empty mapping an empty row is added.

If I use filter for F1 P&L items then that empty row is not coming.

Thanks for your support.


Benoit
Community Manager
Forum|alt.badge.img+15
  • Community Manager
  • May 17, 2023

Hi, thank you for your answer and glad it’s resolved.

It’s interesting to know!

Have a great day!