Forum Discussion
Create a comparaison report based on the same table
Hello, I have already ask some question. But i need your advice conserning a complex report. There is what I want to do : My problem is more complex because I have several column an...
In this scenario, if you want to show the existing "Supplier" on both periods, it should show "M2" for "2015-1" and "2016-1". When you selelect "2015-1" and "2016-1" in slicer, it will filter all corresponding Supplier records for these two periods. We can filter the Suppliers with Cost for both periods. However, it's not possible to have records "aggregate" on Supplier level and split all costs into different columns. We can onlly CONCATENATEX() those costs into single column.
Regards,