Forum Discussion
calculate formula
I trying to pull through the total sales from another table but i want it to show the break down as per each payment category which is cross referenced by index numbers. The formula i'm using is Colu...
Hi Habib,
Below is a screenshot of the table i have created and the error message.
What i'm after is a breakdown of the total supplier spend by payment category.
andywil456CALCULATE function expect filter as second parameter but in your scenario your are providing column value. Please add some filter option like ALL or ALLSELECTED.