1) Create a Calculated field as below.
Name: Current Month Sales
Syntax:
if year([Order_Date])= year(today()) and month([Order_Date])= month(today())
then ([Sales]) end
2) Drag the [Region] on to Rows shelf, [Current Month Sales] onto Columns Shelf.
No comments :
Post a Comment