The Aggregation Scope

We have data on Date level.

Dimensions: Date,CategoryName

Measures: Sales,Amount.

Data:
load *,Date#(Month&’-‘&Year,’MMM-YYYY’) as MonthYear;
load *, Month(Date) as Month,Year(Date) as Year;
LOAD CategoryName,
Date,
Sales,
Amount
FROM
Data.xlsx
(ooxml, embedded labels, table is [Data]);

1.PNG

2.PNG

Sum (TOTAL Amount) >> Will change the value with the selection

Sum({1} Amount) >> Won’t change the value with selection and will give the value from entire document.

 

Data: Data.xlsx

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.