Hi Marcia,

Have you taken the time to review our robust Support Documentation?

https://www.labkey.org/Documentation/wiki-page.view?name=default

Many of your questions can be answered in our docs and we even have videos to help you understand how to both use LabKey and understand the functionality:

https://www.labkey.org/Documentation/wiki-page.view?name=videos

For future, please do your best to consult our fantastic docs first before posting to the Community Forums.


Regarding your PIVOT query, have you reviewed our PIVOT documentation?

https://www.labkey.org/Documentation/wiki-page.view?name=pivot

The query you provided looks malformed and without knowing more details of the actual data, doing a PIVOT may not be possible depending on what is within those respective columns and the groupings.

Regards,

Jon