Discussions
-
Smart Text to allow formatting of Date Variable
Currently if you use a date Variable in Smart Text it is limited to YYYY-MM-DD format (or per locale). If would be great to be able to format based on criteria, including fiscal formatting. e.g. For 31/12/2022 it would be Q2 FY23.
-
Pivot Table - restrict collapse/uncollapse for end user
Hi, I have a business need where I am using a pivot table to display rows of financial data which mimics a Profit and Loss report. Each subtotal section is a copy of data with dimensions. This is working well and giving the desired results. Except for the report rows which are subtotals where I would not want the row to be…