Thursday, 5 November 2015

Current month Data in the Report for Regions.



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