Customizing cross table totals

[Priyank Dwivedi]

Hello,
In a cross table, there is a simple way to show totals for an entire column but is there a way to show Quarterly totals like shown below assuming I have monthly data?

Default view in a cross table:

 

Well	Date	Prod
WellA	1/1/2024	10
WellA	2/1/2024	20
WellA	3/1/2024	50
WellA	4/1/2024	50
WellA	5/1/2024	50
WellA	6/1/2024	50
WellA	7/1/2024	100
WellA	8/1/2024	50
WellA	9/1/2024	100
WellA	10/1/2024	50
WellA	11/1/2024	100
WellA	12/1/2024	100

 

Expected (Or I am open to other setups where I can see quarterly summation in a cross table)

 

 

Well	Date	Prod
WellA	1/1/2024	10
WellA	2/1/2024	20
WellA	3/1/2024	50
	Q1	80
WellA	4/1/2024	50
WellA	5/1/2024	50
WellA	6/1/2024	50
	Q2	150
WellA	7/1/2024	100
WellA	8/1/2024	50
WellA	9/1/2024	100
	Q3	250
WellA	10/1/2024	50
WellA	11/1/2024	100
WellA	12/1/2024	100
	Q4	250

[Gaia Paolini]

You should be able to do so by adding the quarter column to the columns of the cross table

[Priyank Dwivedi]

Thanks, Gaia. I will try that.

Along the same line, is there a way to hide one of the variables in the "vertical" axis? For example, if a user selects "hide/show" setup as a dropdown for the vertical axis 'Type'.

I would like to entirely hide the column 'Type' when a user selects Hide from the dropdown. I am wondering if there is an ironpython aPI that I can use.

Show:

Asset	Mode	Type	Var	Jan	Feb	Mar	Apr
EAST	Base	High	Net BOE Rate (Final)	1,000	1,000	1,000	1,000

Hide:

Asset	Mode	Var	Jan	Feb	Mar	Apr
EAST	Base	Net BOE Rate (Final)	1,000	1,000	1,000	1,000

[David Boot-Olazabal]

Hi Priyank,

You can hide columns via the properties of a visualization. Using the Show/Hide parameter, you can add a rule which hides or shows a column.

You can also trigger this via an iron python script, and the one below can act as a starting point: 

 

Note that you need to tailor it to a crosstab, since the example uses a bar chart, but the idea behind it should be the same.

Kind regards,

David