View original (French)

Pivot table + merged cells

Solved
oreyi19 Posted messages 8 Status Member -  
oreyi19 Posted messages 8 Status Member -
Hello,

I need quick assistance to solve a problem with merged cells and a pivot table.

For the last 3 years, I’m summarizing the types of offers sold in general + details by client.

I created my pivot table with the desired values. However, when I sort by client, I have a (blank) field corresponding to my merged cells.

How can I ensure that the values from these merged cells are directly associated with the client and the product? And how can I avoid duplicating the amounts and totals from my source table?

I’m attaching my file for more details > http://www.cjoint.com/c/GLmrgjxErrP

Thank you in advance for your help.

3 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    For quick assistance to resolve an issue with merged cells, it's very simple, you just need to unmerge them.

    When you merge cells for a presentation, no problem.
    However, as soon as you want to interact with that range, sorting, copying/pasting, etc. no longer work.

    It's up to you to choose, but merges are very limiting!
    --
    Always zen
    Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    1
    1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
       
      I wouldn't have answered anything else!
      0