Focal Point
[SOLVED] Having multiple columns in a pivot table

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/6537092986

February 12, 2018, 09:45 AM
PO
[SOLVED] Having multiple columns in a pivot table
I have a report that I want to display multiple columns in a report like, name, email, room number etc and sum by date field. I get the error message (FOC029) All sort keys are not in a single top-to-bottom segment path.
Does someone know how I could get me display regardless the number of columns.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8105
Windows, Excel
February 12, 2018, 10:17 AM
FP Mod Chuck
PO

It sounds like the master file being used has JOIN's in it that are joined using 1 to many. Try changing the joins to be unique and I think this issue will go away.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
February 12, 2018, 03:46 PM
PO
That worked.

Thanks


WebFOCUS 8105
Windows, Excel