A business analyst must display current year sales versus previous year sales by region, sub-region and city. The result will be a pivot table, with rows for the region, sub-region, and city, and columns for Current Year Sales and Previous Year Sales. Which calculated expressions should the business analyst create to meet these requirements?
A business analyst is testing an existing application that returns some unexpected results. Using the selection tool the business analyst observes the following:
When you select the Category field and the contents of Doc remain white. Selects the Year field and all Doc records become gray. Select some content in Doc and the Contents of Week are all gray, but the contents of Category are white. Selects a content from the ProductID field and the associated field ShipperID and Date remain white, but the Year field is grayed out.