I have problem with formatting drill results in Excel.
I have drill view that has formatting with no decimals and thousands separator.
It is displayed exactly as expected within Cube Viewer.
But when I make drill within excel worksheet, I have completely unreadable formats with no separator and variable number of decimals.
Is there ability to manage format of the drill?
Thanks.
Default drill format
-
4rtem
- Posts: 12
- Joined: Wed Nov 20, 2013 5:05 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2007
Default drill format
“The way to get started is to quit talking and begin doing.” - Walt Disney
-
jim wood
- Site Admin
- Posts: 3958
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Default drill format
Where are you drilling to and what method? You'll need to give us a lot more info.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7