Otherwise, add the column in your source data. If you want to subtract two columns in a Pivot Table, you need to create a Calculated Field as in, subtract a from b. I have tried to add an expression (which works in my straight tables) but that results in two columns below budget and two below actual. Subtract two columns in a pivot table I have made a pivot table where i need to subtract the two scenarios Budget and Actual to be displayed in a Remaining column. I would like to achieve to get a pivot table like the example table below. To calculate the value for the sum of remain column i tried to use a calculated field but I got wrong results (see below). Using a pivot table i solved my first and second question. Is there some possibility to create PIVOT with gradual subtracting of values in individual columns? Pivot table subtract two columns
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |