I need a table with Type as a dimension
it should have the values
however in the source data the field Type has 3 values only those are Medium, Small, Large.
the Medium-to-Small rate is the ratio of Small/Medium also the Small-to-Large rate is the ratio of Large/Small.
Type 2015 Sep
Medium-to-small rate 65%
Small-to-Large rate 90%
Medium-to-small rate 65% can be obtain by calculating the Small Value/Medium Value, Here 34558/52840 =65%
Small-to-Large rate 90% can be obtain by calculating the Large Value/Small Value, Here 31040/34558=90%