Hi all, my tax director is asking for a consolidat...
# general
c
Hi all, my tax director is asking for a consolidated trial balance by subsidiary report, however they'd like the entities to appear in each column, and their debit/credit to show it in their local currency. Does anyone know how I'd go about doing this?
k
use Analytics pivot
c
Hmmm okay I'll try that out
k
for this one this is the way
c
Do you know if there's a way to export workbook results as a CSV? I'm not seeing it anywhere
nevermind I found it lol
So it looks like a coworker already made a workbook, but when I try to export it as a CSV, it goes back to three columns like the original saved report.
image.png
k
give a link to your tax director instead? I do not often use the export feature, cannot help you here
share the workbook that is
c
Ok no worries, let me send it over. Thank you for your help!
l
In 2024.2 version, it's now possible to download the pivoted results (not converted to plain table anymore).
We have Swiss subsidiary where the base currency is USD. How can we get the Swiss financials in CHF? Is that possible?