OK, I got my measures working - using Calculate. However, now instead of my report appearing as follows..
Month to date
Revenue
Revenue headings..
Widgets
Yokes
Total revenue = 50,000
COGS
Steel
Soap
Total COGS = 35,000
GROSS PROFIT = 15,000 (which I have the correct number for)
it's now appearing as another column beside my Month to Date column instead of a single Gross profit entry...
How can I get it to appear as a single entry just for that month? thank you
Month to date
Revenue
Revenue headings..
Widgets
Yokes
Total revenue = 50,000
COGS
Steel
Soap
Total COGS = 35,000
GROSS PROFIT = 15,000 (which I have the correct number for)
it's now appearing as another column beside my Month to Date column instead of a single Gross profit entry...
How can I get it to appear as a single entry just for that month? thank you