Hide Quarter on X-axis

[chinmay7]

Hi,

I came across one requirement where we want to hide our Quarter on axis for which one of the month does not have data.

means show quarter only if that has data for all 3 months.

[sugathirajkumar]

A:
load * inline [
Month, Quarter,year,Sales
January, Q1,2018,100
February, Q1,2018,200
March, Q1,2018,100

April, Q2,2018,300
June, Q2,2018,400

July, Q3,2018,100
August, Q3,2018,300
September, Q3,2018,200

October, Q4,2018,100
December, Q4,2018,400
];
exit script;

Dim:=if(aggr(count(Month),Quarter)=3,Quarter)
Meas:sum(sales)
if you have 4 months under one quarter then change the count from 3 to 4.

[shiveshsingh]

sample data?

[sugathirajkumar]

[Brett_Bleess]

Chinmay, did Sugathi's posts help you get what you needed?  If so, please do not forgot to circle back and give them credit by using the Accept as Solution button on the post that helped.  If you have done something else, please consider posting that solution and making that as the solution with the button after you post it.  If you require further help, please provide an update on where things stand. 

Regards,
Brett