Filtering
The pre-filter lets you filter on any combination of fields and values - just try doing this in a Pivot table!
Field table
The Field table presents all the fields available for your
analysis in one organized area. Compare to the Field List in a
Pivot table or the dimension tabs in PerformancePoint - you’ll
never get lost again!
Fields used in the PivotGrid are colour-coded to help you
know what you’re looking at. Used fields are BLUE; Filtered
fields are RED
The transactions in Pickax™ have already been converted to
your single reporting currency, so you can see GAAP-
compliant Reporting values for your transactions AND
balances. As well, you can generate analyses & reports using
the functional currency values that were imported - the choice
is always yours. And your Dynamics GP data is always the
starting point!
Data Sets
Sort by Tree
Q: When does “Revenue” come before “Operating Expenses”?
A: In an Income Statement!
Pickax™ allows you the option to sort your Natural Accounts by
alphabet or, more usefully, in the same order as you set them up
in the Account Tab.
Dynamic Reports