Community
IBM Community Home
AIOps & Management
Business Analytics
Business Automation
Cloud Pak for Data
Data Science
DataOps
Hybrid Data Management
IBM Japan
IBM Z & LinuxONE
Integration
Internet of Things
Power Systems
Public Cloud
Network Automation
Security
Storage
Supply Chain
Watson Apps
WebSphere & DevOps
Log in
Announcements
Blogs
Groups
Discussions
Events
Glossary
Site Content
Libraries
on this day
between these dates
Posted by
Announcements
Blogs
Groups
Discussions
Events
Glossary
Site Content
Libraries
on this day
between these dates
Posted by
Skip to main content (Press Enter).
Sign in
Skip auxiliary navigation (Press Enter).
Business Analytics
Topic groups
Cognos Analytics
Cognos Controller
IBM Spectrum Computing
Planning Analytics
My Groups
User groups
All User Groups
Events
Upcoming Business Analytics Events
On Demand Webinars
IBM Expert TV
Virtual Community Events
All IBM Community Events
Participate
Post to Forum
Share a Resource
Blogging on the Community
Connect with Business Analytics Users
All IBM Community Users
Resources
IBM Support
IBM Cloud Support
IBM Champions
Demos
Marketplace
Marketplace
Community
Connect, learn and share with over 100,000 users across IBM Community.
Join / Log in
Explore BA Products
Skip main navigation (Press Enter).
Toggle navigation
Content types
Announcements
Blogs
Groups
Discussions
Events
Glossary
Site Content
Libraries
Date range
on this day
between these dates
Posted by
Planning Analytics
View Only
Group Home
Discussion
2.3K
Library
90
Blogs
155
Events
4
Members
1.7K
Back to Blog List
Getting started formatting Dynamic Reports in #Planning Analytics for Microsoft Excel
By
CHARLIE LE
posted
Wed June 28, 2017 10:53 AM
Options Dropdown
Mark as Inappropriate
0
Recommend
Do you find formatting new and existing data from your organization too complex?
Dynamic Reports are an excellent way to modify data in IBM® Planning Analytics for Microsoft Excel. You can use Dynamic Reports to format and visualize your organization's data for optimized performance.
The formatting in a Dynamic Report is specified by format definitions within the format range. You can change the formatting of a Dynamic Report by editing the cell format, adding new format definitions or modifying existing format definitions.
By default, the format range is hidden.
Before you can create new format definitions or modify the default format, you must reveal the format range.
The following video shows you how to reveal the format range and how to modify existing format definitions in Planning Analytics for Microsoft Excel.
Open the full tutorial in YouTube
and follow along with the
product documentation
.
Watch the video
#tutorial
#Resources
#Video
#PAPost
#dynamicreports
#Education
#Planning Analytics for Microsoft Excel
#formatting
#GettingStarted
#Tips
#youtube
#analytics
#videos
#Tutorials
#PlanningAnalyticsForMicrosoftExcel
0 comments
8 views
×
Reason for Moderation
Describe the reason this content should be moderated (required)
Permalink
Business Analytics
Topic groups
Cognos Analytics
Cognos Controller
IBM Spectrum Computing
Planning Analytics
My Groups
User groups
All User Groups
Events
Upcoming Business Analytics Events
On Demand Webinars
IBM Expert TV
Virtual Community Events
All IBM Community Events
Participate
Post to Forum
Share a Resource
Blogging on the Community
Connect with Business Analytics Users
All IBM Community Users
Resources
IBM Support
IBM Cloud Support
IBM Champions
Demos
Marketplace
Marketplace
Copyright © 2019 IBM Business Analytics Community. All rights reserved.
Powered by Higher Logic