Issue on data displaying ‘1’ instead of the actual number value.
It does have value in the retrieve data like the one’s highlighted in yellow, the red ones are only showing 1.
Thank you for writing to us.
It would be helpful for our investigation of the issue if you could provide us with a dummy sample of your data as well as your pivot table report configurations. This will let us see the whole picture more clearly and understand the nature of the issue beter.
Thank you in advance and looking forward to hearing from you.