"The Pivot Table is Only Showing Part of the Data" Error

Tow
Tow Tokyo ⚪️

In our KPI cards using pivot tables, I keep getting the following error.

”This pivot table is only showing part of the data. The visible rows and/or columns are incomplete.”

There doesn't seem to be anything wrong with the DataSet, and I have not been able to identify the cause.

Has anyone else had a similar error?

Tagged:

Best Answers

Answers

  • Tow
    Tow Tokyo ⚪️

    Thank you @amehdad. I couldn't find any information about this error and it helped me a lot.

  • Tow
    Tow Tokyo ⚪️

    Hi @GrantSmith, thank you very much for your help. I set the number of rows from "Filter and Sort" in Analyzer and I was able to solve our problem!