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