• 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.

problems performing a subtraction between two fields of a Pivot table

Hermes

New Member
I have trouble performing a subtraction between two fields in a Pivot table.
I want to subtract the Close and Open fields. With the purpose of being able to realize the graph that is shown in the figure.
But I get the message showing in the figure.
regards
Hermes
upload_2017-3-30_13-48-36.png
 
Last edited:
I attached excel file. I need to add the rows of the field AcumuladoO consecutively to make the graph shown.
Thank you and awaiting your comments and guidelines
 

Attachments

  • Copy of Reportes de ProyectosRcopy2.xlsx
    212.9 KB · Views: 3
Proyecto .jpg Good morning everyone
Achieve target using Defined Names to take the data from a pivot table and performing multiplication with the help of the lower triangular matrix. All as shown in the figure.
Is it possible that a matrix of 20x20 with zeros and ones, make me so heavy the excel file?
I have not been able to reduce the size of it so I can upload it to the forum !!!!
Good morning
Hermes
 
With the help of this macro I create the matrix

Sub GenerateMTI()
Dim F As Integer, C As Integer

For F = 1 To 54 'Weeks in the year
For C = 1 To 54
If F = C Or F < C Then Cells(C, F) = 1
If F > C Then Cells(C, F) = 0
Next
Next

End Sub
 
Back
Top