• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Doubt

Ram Chandran

New Member
Hi Guys,
I have prepared Pivot Table in that i need to split sum values into two rows.
Is it possible can we split the single value into two rows.
DateAmt
11​
12340​
split this to two rows 1st row 8000 remaining on next row.
12​
3000​
13​
4590​
14​
23000​
15​
16780​


Kindly suggest.
Thanks in advance.
 
Ram Chandran
Is above Your source data or Pivot-table?
How to know, which single value should split?
Could You send a sample Excel-file, which shows sample data as well as expected results.
 
Ram Chandran
Is above Your source data or Pivot-table?
How to know, which single value should split?
Could You send a sample Excel-file, which shows sample data as well as expected results.

Hi vletm,
Thanks for your reply.
I have attached the file kindly check. I have highlighted the result which i need.
Result not only in pivot anyother ideas also fine.

Thanks in advance.
 

Attachments

  • Pivot Exercise.xlsx
    13.5 KB · Views: 2
Ram Chandran
Based Your sentence: Result not only in pivot anyother ideas also fine.
You could set 'any value' to source-sheets cell B2
 

Attachments

  • Pivot Exercise.xlsb
    19.7 KB · Views: 3
In the attached, adjust the 8000 in cell H1 of the result sheet (it's a named range called myMax), then refresh the table at cell G3.
 

Attachments

  • Chandoo48527Pivot Exercise.xlsx
    22.6 KB · Views: 1
Back
Top