Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Salesforce Lightning Reporting and Dashboards

You're reading from   Salesforce Lightning Reporting and Dashboards Create, customize, and manage your Salesforce reports and dashboards in depth with Lightning Experience

Arrow left icon
Product type Paperback
Published in Aug 2017
Publisher Packt
ISBN-13 9781788297387
Length 402 pages
Edition 1st Edition
Concepts
Arrow right icon
Author (1):
Arrow left icon
Johan Yu Johan Yu
Author Profile Icon Johan Yu
Johan Yu
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. Fundamentals of Salesforce Reports and Dashboards FREE CHAPTER 2. Concepts and Permissions in Reports and Dashboards 3. Implementing Security in Reports and Dashboards 4. Creating and Managing Reports 5. Understanding Report Types 6. Advanced Report Configuration 7. Adding Charts in Reports and Pages 8. Working with Reports 9. Building Dashboards in Lightning Experience 10. Learning Advanced Dashboard Configuration 11. Advanced Tips and Tricks for Reports and Dashboards 12. Dashboards and Reports in the Salesforce1 Mobile App

Function formulas

There are two functions in Salesforce available only in the summary formula and considered the most powerful report formula. They are categorized under the Summary functions: PARENTGROUPVAL and PREVGROUPVAL.

The PARENTGROUPVAL() function

The PARENTGROUPVAL() function returns the value of a specified grouping; the grouping level is higher than the formula display level.

The formula syntax is different depending on the report format:

  • In the Summary and Joined reports: PARENTGROUPVAL(summary_field, grouping_level)
  • In the Matrix report: PARENTGROUPVAL(summary_field, parent_row_grouping, parent_column_grouping)

Using...

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 €18.99/month. Cancel anytime