Table - Multiple Calculations stacked

[jono19872002]

Hi

I'm sure it is possible, but wanted to know how i can manipulate a table so show two calculations seperately within the same column

eg top half of table sum sales by the region dimension and then underneath a summarised row of total prior year (not split by dimension)

eg

		April	May	June
	UK	10	10	15
	EU	15	10	20
	USA	20	15	20
	Total Sales	45	35	55
	Prior Year	55	69	70

[chrismarlow · Accepted solution]

Hi,

A way I've seen involves using a calculated dimension with a ValueList (depends on you region having a smallish fixed number of values) & then Pick/Match to write an expression for each row, so something like the below (but will be very dependent on your data model, so have cut a lot of corners here);

Cheers,

Chris.