Calculated Field Creates a lot of rows
The attached picture shows my problem, as soon as I am using a Calculated Field the first column is being divided into multiple instances until I aggregate the column where my Calculated Field is.
In the case of a variance in £, this is not a problem, however, the problem is when I try to calculate the percentage difference.
I'd like to use a Calculated Field because I'd like to have calculated total as well, which is not possible with advanced functions.
The first column is a drill-down column, is that causing that issue?