I have a BAQ that I have the data I require, but I need to if possible show only the price once. Unless there is a way to display the total on the dashboard without requiring the column which repeats the data for each operation and therefore repeating the amount as well.
Depending on how you were querying, you might could get away with some calculated fields,
and some logic. Even a rownumber over. Lot’s of options in 10 or 11.