Pivot Doubt

[Ram Chandran]

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.

Date	Amt
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.

 

[vletm]

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]

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.

 

[vletm]

Ram Chandran
Did You answer somewhere?
How to know, which single value should split?

 

[Ram Chandran]

No..

 

[Ram Chandran]

All the values should be not more than 8000.
This is the result i need.

thanks in advance

 

[vletm]

Ram Chandran
Based Your sentence: Result not only in pivot anyother ideas also fine.
You could set 'any value' to source-sheets cell B2

 

[Ram Chandran]

Thanks a lot.. The result is awsome...
Thank you for your valuable time..

 

[p45cal]

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.

 

[Ram Chandran]

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.

Hi,

Thanks a lot.. The result is awsome...
Thank you for your valuable time..