Search icon
Subscription
0
Cart icon
Close icon
You have no products in your basket yet
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Learning SAP Analytics Cloud

You're reading from  Learning SAP Analytics Cloud

Product type Book
Published in Jul 2017
Publisher Packt
ISBN-13 9781788290883
Pages 420 pages
Edition 1st Edition
Languages

Table of Contents (11) Chapters

Preface 1. Getting Started with SAP Analytics Cloud 2. Models in SAP Analytics Cloud 3. Planning model 4. Creating Stories Using Charts 5. Extending Stories with KPI, Filters, and Other Handy Objects 6. Analyzing Data Using Geomaps and Other Objects 7. Working with Tables and Grids 8. Collaboration 9. Digital Boardroom 10. System Administration

Applying a date filter

The current status of the page is depicted in the following partial illustration. As you can see, the contribution of Kiran Raj towards net revenue in the chart is showing 161.79 million (A), whereas the table is showing 64.69 million (B) for the same sales manager. This is due to the filter applied on the table data in step 29 to restrict the table results to 2016. Execute the following steps to apply a similar filter to the chart to match the results:

  1. Select the chart, and then click on the Add Filters link (C) located at the bottom of the Builder panel. From the list that pops up carrying the list of dimensions, select Date (Member) (D).

This will show a Set Members for Date window. In this window, select 2016 (E) and click on OK. The chart's figures (F) now match those shown in the table:

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $15.99/month. Cancel anytime}