Hi @PetriRoine . I am not sure but i think my version is SAS VA 9.4. Please, see in the image left, what my cross tab should ressemble. In the image, they use a table list but i need to use a crossTab for hierarchy variable. I want to use Hierarchy variable(fiscal year, month of year) instead of Order_Date in the image. So my crosstab will display cumulative profit by year (when you click in fiscal year) and cumulative profit by month... Thanks for your help.     ... View more

Unfortunately I don't have SAS VA on Viya to be able to help you further since you are using the Data Explorer interface. Please be aware though that SAS Studio is available to you under VA so you could indeed use SAS code to import this data to give you more control.  ... View more