Tips and Tricks

Exercise: Create below shown report in Webi using club database on SQL Server.

To make above shown report in Webi case function is required to cut slices of data for each year. Case function is used to convert rows into columns or it also called Pivoting a table.  Pivoting is called as Transposing data