Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excell problem with pivot table

Copper Contributor

Let me try to explain: imagine you have a bank statement, of 5 years period , with data in every year , month, and different daily entries. The data columns are: Year / Month / Descripition / Value. A pivotable executed, by year, month, and all months, shows the full opening down to individual values by each entry. EXCEPT for one month, the “July”, it only presents: a blank field for “descripition” , and “in total values” ( shows the value, the sum of the totals, of each of the items. It doesn't open, a line for every “descripition item”.                                                                                       xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx                  

I have open the “excell file” on another device, and it continues to show same problem. My conclusion is that I'm having some kind of problem with the file in question. How to find what is it, and how to correcte? Best regards Alfredo Guedes

1 Reply