How to combine multiple pivots into one pivot in oracle fdi workbook..
Hi @SaravananPandian
You could create multiple Canvases, each with its own Pivot.
Also, one Dashboard could include multiple pivot Visualizations.
You generally can’t merge several existing pivot views into one. Build one pivot from the combined data instead. If the pivots are from the same FDI subject area: Create or edit one analysis/workbook. Add the common row attributes once. Add the measures from each pivot to the same visualization. Put the comparison attribute—such as fiscal period, scenario, ledger, or category—on the pivot columns. Use filters or calculated measures to distinguish each prior pivot’s subset.
See the documentation here: https://docs.oracle.com/en/cloud/saas/analytics/23r2/fawug/create-workbook-and-add-visualizations-fawug.html
Regards,
John
