Inforiver
Analytics+
Analytics+
  • Introduction to Analytics+
    • Installing Analytics+
      • Install for yourself
      • Installing from AppSource
      • Installing for your organization
    • Licensing and manual renewal
  • Working with Analytics+
    • 1. Navigating the Analytics+ toolbar
      • Chart toolbar
      • Card toolbar
      • Table toolbar
    • 2. Data Management
      • Advanced pivot
      • Adding calculated measures
    • 3. Charts
      • 3.1. Charts - getting started
      • 3.2. Quick options - charts
        • X-axis customizations
        • Y-axis customizations
      • 3.3. Configure measures for charts
      • 3.4. Configure dimensions for charts
      • 3.5. Chart discoverability
      • 3.6. Data label customizations
      • 3.7. Deviation
      • 3.8. Display settings for charts
        • Charts - canvas settings
        • Charts - axis settings
        • Charts - number settings
        • Charts - legend settings
        • Charts - other settings
          • Charts - tooltip settings
    • 5. Cards
      • 5.1. Cards - getting started
      • 5.2. Quick options-cards
        • KPI customizations
        • Chart customizations
      • 5.3. Configure measures for cards
      • 5.4. Configure dimensions for cards
      • 5.5. Insight charts
      • 5.6. Variance customizations
      • 5.7. KPI containers
        • Working with Groups
        • Working with Flex components
      • 5.8. Inserting formulas & text
      • 5.9. Card customizations
      • 5.10. Display settings for cards
        • Cards - canvas settings
        • Cards - number settings
        • Cards - legend settings
        • Cards - axis settings
        • Cards - other settings
          • Cards - tooltip settings
    • 6. Tables
      • 6.1. Tables - getting started
      • 6.2. Quick options - tables
      • 6.3. Configure measures for tables
      • 6.4. Configure dimensions for tables
      • 6.5. Formatting data
      • 6.6. Number formatting
      • 6.7. Inline charts
      • 6.8. Blend measures
      • 6.9. Row gripper options
      • 6.10. Display settings for tables
        • Tables - canvas settings
        • Tables - number settings
        • Tables - other settings
          • Tables - tooltip settings
    • 7. Trellis customizations
      • Charts trellis layout
      • Cards trellis layout
      • Tables trellis layout
    • 8. Customize measures
      • Charts measure series
      • Cards measure series
      • Tables measure series
    • 9. Splitting and grouping measures
      • Splitting and grouping: charts
      • Splitting and grouping: cards
      • Splitting and grouping: tables
    • 10. Conditional formatting
      • One-click rules
        • One click rules for charts
        • One click rules for cards
        • One click rules for tables
      • Configuring rules
        • Configuring rules for charts
        • Configuring rules for cards
        • Configuring rules for tables
        • Variable conditional formatting rules
        • Applying conditional formatting rules
      • Setting color scales
      • Managing rules
    • 11. Sort & Reorder data
      • Sorting data
      • Advanced sorting
      • Reordering data
    • 12. Ranking data - TopN
      • Ranking for charts
      • Ranking for cards
      • Ranking for tables
      • Dynamic ranking with numeric parameters
    • 13. Adding notes
      • Notes for charts
      • Notes for tables
    • 14. Data selection
    • 15. Working with hierarchies
      • Hierarchies in charts
      • Hierarchies in cards
      • Hierarchies in tables
      • Unbalanced hierarchies
      • Single child hierarchies
    • 16. Summary tables
    • 17. Backup and restore
    • 18. Context awareness
    • 19. Image support
      • Images in cards
      • Images in tables
    • 20. Analytics
      • Reference line
      • Reference band
      • Error bar
      • Trend line
      • Additional series
    • 21. Keyboard shortcuts
    • 22. Reading view access
    • 23. Row aggregation
  • Storyboard
    • Element customizations
    • Board customizations
    • Working with textboxes
    • Uploading images
    • Using shapes
    • Inserting slicers
    • Element interactions
    • Layers
    • Navigation
      • Play axis
    • Annotations
  • Gantt chart
    • Gantt: Canvas settings
      • Gantt: General settings
      • Gantt: Column settings
      • Gantt: Grid settings
      • Gantt: Timeline settings
    • Gantt milestones
    • Gantt: Data label settings
    • Gantt: Conditional formatting
    • Gantt: Web URLs
    • Gantt resource
    • Gantt: Zoom levels
  • Quick charts
    • Waterfall charts
    • Marimekko
    • Column/Bar charts
    • Bullet charts
    • Area charts
    • Pie charts
    • Treemap charts
    • Radar/Polar charts
    • Funnel charts
    • Sunburst charts
    • Bubble charts
    • Boxplots
    • Histogram
    • Gauge
    • Storytelling charts
      • Range charts
      • Ribbon chart
      • Tornado chart
      • Multi-variate charts
      • Sankey charts
    • Combo charts
  • Release notes
    • Analytics+ April 2025 update - Release 4.7
    • Analytics+ March 2025 update - Release 4.6
    • Analytics+ January 2025 update - Release 4.5.
    • Analytics+ January 2025 update - Release 4.3
    • Analytics+ November 2024 update -Release 4.2
Powered by GitBook
On this page
  1. Working with Analytics+
  2. 2. Data Management

Advanced pivot

Previous2. Data ManagementNextAdding calculated measures

Last updated 10 months ago

The designer view or advanced pivot enables you to configure measures and categories while observing dynamic updates to the chart/table. When you have many measures and dimensions, the designer view avoids having to open the pivot data window repeatedly to change the configuration.

The advanced pivot interface opens by default when the Analytics+ visual is full-sized or fills 75% of the canvas.

To disable advanced pivot, navigate to Display settings > Others > enable Hide advance pivot.

Advanced pivot overview

The advanced pivot provides all the features discussed in detail in the data management section. The filtering capability is available only in the designer view.

1. Search and filter

Analytics+ allows report creators to add many measures and dimensions to the visual. End users can then leverage the data management capabilities to configure dimensions and measures to create reports. In the search and filter section, you can

  • select the measures and dimensions required for your report by ticking the checkbox next to each measure/dimension category

  • locate measures and dimensions easily using the search bar.

2. Fields

The fields section holds the data wells for the measures as well as the axis, legend, row, and column dimensions.

  • You can map measures to the actual or comparison data wells. Variances will be calculated automatically when you map measures to the comparison buckets.

  • You can assign dimensions to the axis, row, column, and legend buckets.

  • You can also interchange the measures and dimensions between the data wells as required. The charts/tables will be re-rendered automatically based on the changed configuration.

3. Filters

4. Advanced settings

Expand the advanced section to access options like enforcing IBCS standards, splitting measures, and combining row and column dimensions. These options are discussed in detail in the data management section.

You can filter measure values and dimension categories from the filter tab. The interface is similar to the . You can apply basic or advanced filtering.

Power BI filters side pane
Advanced pivot
Selecting dimensions/measures
Searching for dimensions/measures
Assigning measures and dimensions to the data wells
Interchanging measures and dimensions between the data wells
Filtering dimensions
Filtering measure values
Advanced settings