Stacked Bar Chart in %

[Aaseemsood]

 I have a Stacked Bar Chart which i need in %.

I have two Dimensions and one measure.

The expression im using is below:

Count({<Year = {"$(=Max(Year(TODAY())-1))"}, Transaction_Type={'New Booking'},[Service Type]={'Air'},[Dom / INT'L]={'Domestic'}, [Trip anticipation]-={'Undefined','Back Dated'}>} [# of Transactions])

I want a 100% Stacked Bar chart. please let me know if there is a possibility.

[MayilVahanan]

HI @Aaseemsood 

Try like below

Count({<Year = {"$(=Max(Year(TODAY())-1))"}, Transaction_Type={'New Booking'},[Service Type]={'Air'},[Dom / INT'L]={'Domestic'}, [Trip anticipation]-={'Undefined','Back Dated'}>} [# of Transactions]) /

Count(Total <Month>{<Year = {"$(=Max(Year(TODAY())-1))"}, Transaction_Type={'New Booking'},[Service Type]={'Air'},[Dom / INT'L]={'Domestic'}, [Trip anticipation]-={'Undefined','Back Dated'}>} [# of Transactions])

[Aaseemsood]

Hi Mayil Vahanan,

Thanks for the Help.

I could get the % in the Stacked Bar but not a 100% tacked Bar using the suggested formula.

By any chance you could help in making a 100% stacked bar chart.

Thanks Again

Aaseem 

[MayilVahanan]

HI @Aaseemsood 

Can you send ur sample qvf file or sample data?