Hi liamcameron ,
your issue seems more relatedto your data model but to be honest I am not sure I understood exactly what you are looking to achieve. Can you describe more precisely what you expect to see, maybe with a mockup done in excel or on paper +a short description of your data.
In some cases, a pivot will be able to display categories, but in a multi fact model it is likely not to show any result if you don't add KPI's. For table I don't understand what is tour issue. Last question : which version of Sisense are you using ?
Best, David